As far as I can work out, DBMS_STATS is purely for
optimizer decisions (presumably thats why they didn't
call it DBMS_ANALYZE).
(If you believe the doco) you can get faster and
better stats with DBMS_STATS (particularly in terms of
partition-wise stats).
I'm using both at the moment, in my cas
All:
>From reading the release notes for 9i it appears that ANALYZE table and
DBMS_UTILITY.ANALYZE_SCHEMA are desupported in 9i. The only supported way to
generate stats in 9i is DBMS_STATS.
In addition, DBMS_STATS can generate stats for tables in parallel and make
use of the new MONITORING feat
Oracle 8.1.7
AIX 4.3.3
I looked at the docs and it appears Oracle wants you to use dbms_stats to generate
statistics for cbo. I am currently using dbms_utility.analyze_schema.
Should I change to dbms_stats (i know it doesnt give you chained rows, avg free space,
# of unused blocks)? Are th