Re: More on dbms_stats
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: breitliw@xxxxxxxxxxxxx
- Date: Wed, 10 Aug 2005 17:48:23 -0400
Wolfgang Breitling wrote:
It potentially, and likely, creates an awful lot of histograms exactly
BECAUSE the method_opt setting of 'for all columns size 1' is ignored
and replaced with 'for all columns size auto'.
I prefer skewed columns, that is the columns from SYS.COL_USAGE$. I can
only recommend the nice papers
from http://www.centrexcc.com to the general audience. You did an
excellent job explaining the intricacies of the
optimizer to the general audience. Jonathan is writing a CBO book, did
you happen to see it?
--
Mladen Gogala
Oracle DBA
Ext. 121
--
//www.freelists.org/webpage/oracle-l
Other related posts:
