RE: Gathering statistics on 8.1.7.4

Hi Peter

> Should I be using the dbms_stats package or the analyze
> command for this version of Oracle?

If you have partitioned objects I would advise to use dbms_stats. Otherwise analyze.

> Looking at some of the threads in the archives, I note
> that people do not generally recommend histograms.

Of course that is just a point of view ;-)

> If I use dbms_stats.gather_schema_stats, how do I set the
> method_opt parameter so that I do not generate histograms?

FOR ALL COLUMNS SIZE 1
> What is a good starting point for "estimate_percent"?

4.2

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l