juliandyke.com.ppt

Agenda Statistics Strategies ANALYZE DBMS_STATS ANALYZE versus DBMS_STATS System Statistics Automatic Statistics Collection Statistics History Manual Statistics Partition Statistics Oracle 11g Enhancements Statistics Strategies Introduction Only gather statistics when object has changed significantly Consider generating manual statistics for: Very large objects Temporary tables Highly volatile tables Try to collect statistics during a specified window Do not execute SQL statements during statistics collection Use DBMS_STATS parallelism Review sample sizes for very large objects In complex