Mostly good, a couple of drawbacks. From ORACLE
Advantages:
- May be run in parallel against tables, schemas or database.
- Computes exact Global statistics at the table's or index's level.
ANALYZE is able only to build statistics a this level by deduction of
the partition's statistics, which can lead sometimes to some
inacurracies.
- Computes the statistics on different level: Global, Partition,
Subpartition, All.
- May be used for exporting the statistics in user's shema tables. It may
be used later for simulate user's environments.
- May be used for automatic monitoring of statistics.
Drawbacks:
- doesn't compute statistics not used by Cost Optimizer like chained rows
or validation of structure.
- can't compute statistics on Clusters, but only on the tables inside.
You must use ANALYZE for gathering cluster statistics.
"M.a.x G.e.decke" <spam_at_gedecke.de> wrote in message news:<ajsrqm$150e$1_at_redenix.uni-muenster.de>...
> Oracle says, that it is better to use the dbms_stats package than the
> analyze command. Does anybody know what the exact advantages are?
>
> thanx
>
> max
Received on Tue Aug 20 2002 - 12:38:10 CDT