O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Collecting and Analyzing Statistics

Until Oracle 9i, you could have used the COMPUTE STATISTICS option of the ANALYZE command to get faster statistics, especially for newly created indexes, which is not recommended in Oracle Database 10g. The COMPUTE and ESTIMATE clauses of the ANALYZE statement are still supported in Oracle Database 10g for backward compatibility. You may use the ANALYZE command to collect information on free list blocks and to list chained rows. From Oracle 8i, you also have the option of using the DBMS_STATS package to generate more accurate statistics than the legacy ANALYZE command. The DBMS_STATS package gathers statistics on tables, indexes, individual columns, and table partitions. You can even gather statistics on clustered ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required