Compute Statistics after create a index
Petri BRMay 14 2013 — edited May 14 2013Good 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