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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to speed analyzing histograms

Re: How to speed analyzing histograms

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sun, 13 Nov 2005 00:46:37 GMT
Message-Id: <pan.2005.11.13.00.46.37.532788@sbcglobal.net> 





On Thu, 10 Nov 2005 08:54:51 +0000, Jonathan Lewis wrote:



> Collecting histograms

>     "for all columns"

> or

>     "for all indexed columns"

> is almost invariably a bad idea.




It isn't that bad of an idea, if you're a disk manufacturer. 
So, you are suggesting FOR ALL COLUMNS SIZE SKEWONLY, so
that the columns that appear in SYS.COL_USAGE$ will be the 
only ones getting histograms?


-- 
http://www.mgogala.com


Received on Sat Nov 12 2005 - 18:46:37 CST












Original text of this message













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