Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Compute Statistics after create a index

Petri BRMay 14 2013 — edited May 14 2013
Good night, I tryed it before and got no help.
So I'll try it again, because I didn't find it yet.

I have to create some indexes in a production database.

I have a doubt.
Do I need to Compute Statistics after creating indexes?
Or when I create they automatically are computed?

Thanks for any help.


The version I'm using is:
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 11 2013
Added on May 14 2013
2 comments
473 views