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!

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

Hemant K Chitale
A CREATE INDEX automatically computes statistics on the Index (if you want to update Table and Column statistics, you still need to call DBMS_STATS.GATHER_TABLE_STATS --- e.g. if it is a Function Based Index, you need to update Table statistics because the FBI creates an additonal "virtual" column in the table).


Hemant K Chitale
sb92075
Petri BR wrote:
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?
after CREATE INDEX what are the values for the index statistics?
Or when I create they automatically are computed?
Just look at the statistics values after issuing CREATE INDEX & answer the question yourself!
1 - 2
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
482 views