RE: About an old hint question

After upgrading from 7.3.4 to 8.1.7, I tested our SQL that used hints. Mostly there was little or no difference; however, in a few of cases, removing the hint increased performance quite a lot. The best example was removing a Rule hint.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Jesse, Rich [SMTP:Rich.Jesse_at_qtiworld.com]
>
> Because the hint can force a query's explain plan to be "correct" now, but
> horrible as the stats on the objects change with time. We've been burned a
> few times by the hint "patch". Unfortunately, trying to justify the time it
> would take for the whole department to stop what they're doing for a few
> weeks and retest all apps after a change in stats collection versus adding a
> hint here and a hint there is tough.
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).