Re: Optimizer help, get query to run as good as with RULE hint

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Sun, 16 Feb 2003 18:38:37 -0800
Message-ID: <F001.0054EFF1.20030216183837@fatcity.com>

Sounds more and more like a "if a tree falls in the forest and no-one is there" kind of discussion..

We're getting to the stage where there is an indeterminate number of untraceable but deliberate reasons for the optimizer to 'avoid' a hint. Without access to the source code, that's getting pretty close to the statement: "the optimizer ignored my hint"

:-)

• Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote: >

snip

>
> BTW - I still believe quite firmly that hints are
> never ignored. They may be syntactically incorrect,
> there may be bugs, they may never become relevant;
> but I don't think they are ignored. However, I will
> agree
> that there are more and more grey areas in 9.2 where
> the increased scope for (internal) query rewrites is
> so
> extensive that it is becoming a lot harder to decide
> why
> a hint appears to have been ignored.
>
>

---

Connor McDonald
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"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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

Received on Sun Feb 16 2003 - 20:38:37 CST