Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer_features_enable parameter & query plan

Re: optimizer_features_enable parameter & query plan

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 10 Jun 2006 12:58:55 +0100
Message-ID: <s9WdnXL2ZcNtLhfZnZ2dnUVZ8qqdnZ2d@bt.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:4o6g82tt9jkj6s0uf49vosookd0eifbev8_at_4ax.com...
>
> Such sweeping generalization is simply incorrect.
> And remember hints are just what they are: *hints*. They aren't
> *directives*.
>

Apart from a bugs, hints ARE directives that cannot be ignored if they are valid.

Can you send me a reproducible example
where you think a valid hint is being ignored ?

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Received on Sat Jun 10 2006 - 06:58:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US