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: Hints and RBO?

Re: Hints and RBO?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 14 Oct 2000 12:33:39 +0200
Message-ID: <39E83683.7C9A6946@0800-einwahl.de> 






Hi Bill,



"optimizer_mode = choose" will pick cost based optimization if
a) at least one of the used tables has statistics
b) or if there is a hint other than "rule".



That is the defined behaviour of the optimizer and it perfectly explains the
effects you observed.



Martin
Received on Sat Oct 14 2000 - 05:33:39 CDT












Original text of this message













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