NOTE OF ANALYZE

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@]
请使用浏览器的分享功能分享到微信等