Re: The optimizer is ignoring my hints

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 25 May 2004 10:22:52 +0100
Message-ID: <7765c89704052502228453264@mail.gmail.com>

On Mon, 24 May 2004 22:22:35 +0100, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>
>
> Clearly you haven't yet discovered the
> ignore_optim_embedded_hints
> hint.
>
> So if you include this hint as an embedded hint,
> does Oracle ignore it ?

No I haven't discovered this hint, but I do like your philosophical question inspired by it.

> I haven't tested the parameter yet - but here's another
> interesting thought. Oracle Corp. includes hidden boolean
> parameters so that they can be changed in some future release.
> They must be getting confident.

Possibly, I seem to recall that they were confident that the RBO would be replaced in some future release around about 7.3 (or maybe even 7.1.2 something like that), this is of course true for relevant values of "some"

> In answer to your previous question - I think this hint, and
> the description of the parameter, gives the clue about
> profiles, and outlines - the only hints ignored are the
> embedded ones (i.e. the ones you put in the SQL), the
> one stored in the database for a query still apply.
> (I've only tested this for outlines, though).

Cheers

Makes sense

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

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 Tue May 25 2004 - 04:20:02 CDT