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!

analyze tables

59876Dec 12 2002 — edited Jun 17 2008

Someone told me I need to execute command 'analyze table xxxx compute statistics" frequently, is this true??
and how about index?? do I need to run "analyze index xxx compute statistics" as well?

I have a testing database, which I never execute "analyze" command before, but after I execute analyze table & index, how come it is even slower. Anyone has a clue??

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 15 2008

Added on Dec 12 2002

6 comments

2,631 views