Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i - switching to rule based optimizer optimizer
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 Received on Fri Jan 21 2005 - 14:35:20 CST
![]() |
![]() |