RE: Gathering statistics on 8.1.7.4
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <peter.schauss@xxxxxxx>
- Date: Wed, 2 May 2007 18:02:01 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
