My personal preference is 'FOR ALL INDEXED COLUMNS', because I don't see histograms making sense for non-indexed columns. On 03/02/2004 09:44:52 AM, Wolfgang Breitling wrote: > At 05:51 AM 3/2/2004, you wrote: > >is this on metalink or in the docs anywhere? I never saw it? You would > >think that oracle would warn you about over-using histograms. I guess I > >have to be more careful now. > > > >If I use options=>'GATHER AUTO' does oracle make a decision to use > >histograms? If so, what causes that decision? > > If you are using options=>'GATHER AUTO' ( or method_opt=>'... size auto' ) > Oracle consults sys.col_usage$ to decide which columns to probe for > histograms. If the data for the column is sufficiently skewed - in Oracle's > sole discretion - it will build the histogram. So, yes, gather auto is > probably your answer. Not mine as I like to have more control over when, > what and how statistics are gathered. > > > Wolfgang Breitling > Oracle7, 8, 8i, 9i OCP DBA > Centrex Consulting Corporation > http://www.centrexcc.com > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------