Re: ANALYZE_DATABASE - Query ...

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<u%eZ8.2786$zX3.2308_at_news.indigo.ie>...
> The following text puzzled me .
>
>
>
> it's 9.2 supplied package reference DBMS_UTILITY section
>
>
>
> ANALYZE_DATABASE Procedure
>
> This procedure runs the ANALYZE command on all the tables, clusters, and
> indexes
>
> in a database. Use this procedure to collect nonoptimizer statistics. For
> optimizer
>
> statistics, use the DBMS_STATS.GATHER_DATABASE_STATS procedure.
>
> Q : What's a nonoptimizer statistic ?

Chained rows are calculated by analyze but not dbms_stats as the CBO does not consider chained rows in it determination of the best plan. The Performance and Tuning manual (ver 8i) chapter on Gathering Statistics lists number of rows, number of block, empty blocks, and average row length as being collected.

HTH -- Mark D Powell -- Received on Wed Jul 17 2002 - 13:19:00 CDT