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: Creating indexes on a large table

Re: Creating indexes on a large table

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 05 Aug 2005 11:37:35 GMT
Message-Id: <pan.2005.08.05.11.37.35.146789@sbcglobal.net> 





On Tue, 02 Aug 2005 00:04:32 +0200, Sybrand Bakker wrote:



> 10g will use the CBO even if you never analyzed your tables. However

> in that case, it will simply estimate all the required statistics.




There is nothing simple about OPTIMIZER_DYNAMIC_SAMPLING. Those levels
from the tuning guide must be given the proper amount of thought to set it
correctly.


-- 
http://www.mgogala.com


Received on Fri Aug 05 2005 - 06:37:35 CDT












Original text of this message













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