Oracle Database Discussions

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 table compute statistics

INRiJul 6 2012 — edited Jul 6 2012

Everyday my query become slow.
After analyze the table with ANALYZE TABLE tablename COMPUTE STATISTICS ,then the query run faster.
But everyday i have to analyze the table.
what is the reason???

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2012

Added on Jul 6 2012

#general-database-discussions

2 comments

6,480 views