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 -> RULE vs CHOOSE

RULE vs CHOOSE

From: Business Information Services <email_at_bisinfo.com.au>
Date: 1997/08/11
Message-ID: <MPG.e590c7723a1d3f1989681@nsw-newshost.tpgi.com.au>#1/1 







Hi,



Probably another stupid question ... :-)



If the database tables are never analysed is there any point in having 
the OPTIMISER set to CHOOSE (the default) and in fact would it slow 
things down? I mean I don't know what happens in the bowels of Oracle but 
I'd say it would probably spend some superfluous time searching for table 
statistics before using rules.



Any thoughts appreciated.



Rowan McCammon. 
Received on Mon Aug 11 1997 - 00:00:00 CDT












Original text of this message













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