Re: Oracle 9i - switching to rule based optimizer optimizer

Anurag Varma wrote:

> Yes and No.
>
> CBO is still used if you are using a feature which RBO is not aware of
> (IOT, parallel degree on table/index). Also, if your queries are
> hinted, most hints force the CBO to be used.
>
> Anurag

Thanks for correcting my all to short though process leading up to my answer.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)