Maybe you can have your cake and eat it as well?
- Analyze all tables
- Set optimizer_mode to rule in init.ora to keep your app happy
- Use 'choose' hint where you want to use cbo for particular cases (eg adhoc query, end user
reporting) etc etc
hth
connor
- ryan.gaffuri_at_cox.net wrote: > We have a legacy 8.1.7.3 instance that is in RBO mode. My group
does not own it, so we cannot
> change it to CBO.
>
> When I hint anything from an index to ordered, etc... it switches to the CBO and since nothing
> is analyzed, it's an even worse plan... Not allowed to analyze the tables either because it's
> not our property.
>
> Any rules around hinting the RBO in 8.1.7.3? Why would it switch to the CBO from a simple hint?
> I never use the RBO so please bare with me.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available now
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
WIN FREE WORLDWIDE FLIGHTS - nominate a cafe in the Yahoo! Mail Internet Cafe Awards www.yahoo.co.uk/internetcafes
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Apr 01 2004 - 18:36:06 CST