Re: Best way to call dbms_stats

From: MS <qcom_at_attbi.com>
Date: 20 Aug 2002 10:27:45 -0700
Message-ID: <a2b6d46b.0208200927.e844750@posting.google.com>

here is a sample:

begin

     dbms_stats.gather_schema_stats(ownname=>upper('<Schema_Owner>'),
                        ESTIMATE_PERCENT=> 33, BLOCK_SAMPLE=>false,
                         METHOD_OPT=>'for all indexed columns',
degree=>4,
                         GRANULARITY=>'DEFAULT',CASCADE=>true,

OPTONS=>'gather' );
end;
/

This would do a row estimate table/indexes, collect histograms for all indexed columns in the schema specified.

-Madhu S

"M.a.x G.e.decke" <spam_at_gedecke.de> wrote in message news:<ajt51q$16ju$1_at_redenix.uni-muenster.de>...
> thanks for the fast reply
> do you know any websites where I can take a look at sql skripts executing
> the dbms_stats package?
>
> max
Received on Tue Aug 20 2002 - 12:27:45 CDT