The sample size auto just takes too long for us, although I might give that another evaluation as last time I played with it was also with histograms. We plan on using gather monthly and gather empty weekly... -- .. David > David > Oops, I read your posting more closely and it looks as if you are only > gathering statistics on tables that don't have any. Am I reading that > correctly. Also, you might want to consider the SAMPLE SIZE AUTO. With a > fixed percentage you may be undersampling small tables and oversampling > large ones. ---------------------------------------------------------------- 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 -----------------------------------------------------------------