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 -> Statistics and optimizer

Statistics and optimizer

From: Ann Myhre <annmyhre_at_hotmail.com>
Date: Fri, 4 May 2001 08:45:23 +0000 (UTC)
Message-ID: <OE7b4uFM5NKGfVNMnfi00002744@hotmail.com> 






Does anyone know if optimizer will use the costbased method if no 
statistcis is gathered (ANALYZE TABLE etc.)? I have information saying 
that if no statistics is gathered, optimizer will choose the rulebased 
method, and another source saying that then will optimizer (if set to 
CHOOSE) choose some default values includes in Oracle. Help anyone? 



Ann 




--


Received on Fri May 04 2001 - 03:45:23 CDT












Original text of this message













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