Re: Bizarre Cost Based Optimizer?

A copy of this was sent to tedchyn_at_yahoo.com (if that email address didn't require changing) On Fri, 30 Jul 1999 15:10:55 GMT, you wrote:

>Thomas,
> Are hint and rule base optimizer related - i.e.
>would optimzer use rule if hint is used when optimizer_mode=choose or
>cbo ? If this is not true, then what type of hints will use cbo or rule
>respectively ?
>

the optimizer will be the COST BASED optimizer when there is a hint in a query -- unless the hint is /*+ RULE */, then the RBO is used.

If you hint a query, cbo kicks in.

>Thanks in advance Ted Chyn
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jul 30 1999 - 12:28:45 CDT