Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: More on dbms_stats

Re: More on dbms_stats

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 10 Aug 2005 18:40:02 -0600
Message-Id: <6.2.3.4.2.20050810183804.034ec780@pop.centrexcc.com>


At 05:19 PM 8/10/2005, Mladen Gogala wrote:

>As was gently and privately pointed out, I badly mixed things up yet again.
>The table SYS.COL_USAGE$ is used by 'FOR ALL COLUMNS SIZE AUTO' method while
>FOR ALL COLUMNS SIZE SKEWONLY computes histograms for all columns. I tried
>accusing the manuals, but they did a good job explaining that:
>
>I must be growing old.

Nobody is growing young.

Look at the bright side: consider the alternative :-)

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 19:40:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US