Collect statistics

From Oracle FAQ
Jump to: navigation, search

Three different methods[edit]

Plain analyze command[edit]

analyze table table_name compute statistics;

Schema level analyze using DBMS_UTILITY.ANALYZE_SCHEMA[edit]

execute DBMS_UTILITY.ANALYZE_SCHEMA('EMPI', 'ESTIMATE')

Schema level analyze using DBMS_STAT[edit]