I am starting to generate statistics on an 8.1.7.4 database and I have a few questions. - Should I be using the dbms_stats package or the analyze command for this version of Oracle? - Looking at some of the threads in the archives, I note that people do not generally recommend histograms. If I use dbms_stats.gather_schema_stats, how do I set the method_opt parameter so that I do not generate histograms? - What is a good starting point for "estimate_percent"? This is a 70gb databsae used for a data warehouse application. Data is added from the production database every hour and we have a growth rate of about 20% per year. Thanks, Peter Schauss -- //www.freelists.org/webpage/oracle-l