Re: Cost vs Rule

This shouldn't be a problem, hints just look like comments to other db's.

John

Bill.Magaliff_at_lendware.com wrote:

>not much - desire is to keep sql ANSI compliant due to cross-platform issues
>(want to be able to run the app on multiple db's)
>
>-----Original Message-----
>Sent: Thu, March 07, 2002 2:44 PM
>To: Multiple recipients of list ORACLE-L
>
>
>How much have you played with Oracle Hints???
>
>-Joe
>
>--- "Magaliff, Bill" <Bill.Magaliff_at_lendware.com> wrote:
>
>>I work in a dev shop - most of the sql is canned and pretty basic.
>>We've
>>been running CBO in all of our dev environments, but we have a few
>>long txns
>>that just take forever. At the request of some savvy developers, I
>>turned
>>on RBO, and it brought down execution times dramatically.
>>
>>I've been analyzing affected tables often (we do a lot of bulk
>>load/unload
>>for testing), and have played with partitioning and clustering,
>>particularly
>>on one table that's just a dog. CBO will always do a FTS where RBO
>>uses the
>>PK to retrieve data.
>>
>>Where to go next? I've been unable to alter the costs dramatically
>>enough
>>to make any real difference in execution time.
>>
>>thx
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Magaliff, Bill
>> INET: Bill.Magaliff_at_lendware.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).
>
>
>__________________________________________________
>Do You Yahoo!?
>Try FREE Yahoo! Mail - the world's greatest free email!
>http://mail.yahoo.com/
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: orantdba_at_netscape.net

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).