Oracle-L: RE: SQL statement with hints or without hints

From: <Cherie_Machler_at_gelco.com>
Date: Fri, 12 Apr 2002 11:48:32 -0800
Message-ID: <F001.0044388C.20020412114832@fatcity.com>

Raj,

I don't remember what version you said you were using but you might want to investigate
stored outlines. If you have a full-size test environment, you could save away the current
RBO-based execution plans, switch to CBO and gradually get rid of your RBO-based stored outlines by tuning statements one at a time.

Theoretically, that should work. I haven't tried it myself, though.

Theoretically, it's a way to be on cost-based but continue to use some of the the rule-based execution plans until your comfortable with the new stuff.

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                                                     
                    "Jamadagni,                                                                                      
                    Rajendra"                 To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>    
                    <Rajendra.Jamadagni       cc:                                                                    
                    @espn.com>                Subject:     RE: SQL statement with hints or without hints             
                    Sent by:                                                                                         
                    root_at_fatcity.com                                                                                 
                                                                                                                     
                                                                                                                     
                    04/12/02 01:18 PM                                                                                
                    Please respond to                                                                                
                    ORACLE-L

Thanks Tim,

At-least now I know I shouldn't tell them to start putting hints. This was my problem to tell them or not to tell them. This still doesn't solve the problem for me though, as everyone is still reluctant to move to CBO. And this is exactly where it gets getting complicated.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
(See attached file: ESPN_Disclaimer.txt)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



application/octet-stream attachment: ESPN_Disclaimer.txt

Received on Fri Apr 12 2002 - 14:48:32 CDT