Re: gather_schema_stats

No. The Gather OPTION is only useful if doing table monitoring. Use Cascade=true.

Gather_schema_stats is perilous due to the unexpected changes that can occur in plan changes .... i.e. it's a big stick.

Is this an attempt to do set peoplesoft_go_faster=true ? "Chuck" <chuckh_at_softhome.net> wrote in message news:akdcrk$1h5oo8$1_at_ID-85580.news.dfncis.de...
> Does dbms_stats.gather_schema_stats gather index stats by default or not?
> The documentation on the CASCADE parameter seems to indicate that it does
> not, but the documentation on the OPTION parameter seems to indicate that
it
> does. First it says that CASCADE must be set to true (default is false) to
> do indexes. But the default for OPTION is "GATHER" which means to gather
> stats on *all* schema objects and the last time I checked, indexes were
> considered objects. If I run the following, will it or will it not gather
> index stats?
>
> BEGIN
> DBMS_STATS.GATHER_SCHEMA_STATS(
> ownname => 'PSOFT',
> estimate_percent => 25);
> END;
>
>
Received on Mon Aug 26 2002 - 09:34:34 CDT