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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 16:49:43 CDT
