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: Oracle 9i - switching to rule based optimizer optimizer

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

From: Anurag Varma <anuragvidya_at_gmail.com>
Date: 21 Jan 2005 12:35:20 -0800
Message-ID: <1106339720.014083.276590@z14g2000cwz.googlegroups.com>

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

Original text of this message

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