SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why RBO might be better than CBO ?

user517698Dec 6 2006 — edited Dec 7 2006

Hi ,

I have a query that references 4 base tables , indexes have been created and analyzed

but when using CBO it's is very slow and it's fast when using the RULE hints.

is this something to do with the logic of the query ?

pls advise

tks & rdgs

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2007

Added on Dec 6 2006

15 comments

517 views