Do not use the COMPUTE and ESTIMATE clauses of
ANALYZE to collect optimizer statistics. These clauses are supported
for backward compatibility. Instead, use the DBMS_STATS package,
which lets you collect statistics in parallel, collect global statistics
for partitioned objects, and fine tune your statistics collection in
other ways. The optimizer, which depends upon statistics, will
eventually use only statistics that have been collected by DBMS_STATS.

You must use the ANALYZE statement (rather than DBMS_STATS)
for statistics collection not related to the cost-based optimizer, such
as:
■ To use the VALIDATE or LIST CHAINED ROWS clauses
■ To collect information on freelist blocks

[@more@]

ITPub博客

NOTE OF ANALYZE

最新文章