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 TABLE vs DBMS_STATS.gather_table_stats

User_1JDDGOct 22 2013 — edited Oct 23 2013

Hi,

I have some tables wuth millions of records and my functions perform some queries on them. I need to improve the duration of these querires an i need to know wich is actually the best way to perform statistics on those tables, with ANALYZE TABLE or with DBMS_STATS.gather_table_stats ?

Best regards,

Nuno

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2013

Added on Oct 22 2013

5 comments

1,274 views