Which phase (probably the wrong column name,
maybe stage) of the plan shows RULE - does it
stand alone in the first phase, perhaps ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Connor McDonald wrote in message <3BE9AD58.63A4_at_yahoo.com>...
>When capturing stored outlines for session running with an optimizer
>mode/goal of rule, the list of hints for a typical SQL contains both
>access path hints AND the rule hint, (say):
>
>INDEX(emp emp_ix)
>FULL(dept)
>RULE
>
>The question is: If the rule optimizer has not changed since version
>"blah", surely then, just the RULE hint would suffice
>
>Alternatively, I've yet to generate an SQL where the hints *other* than
>the RULE hint are not sufficient to force the expected plan which would
>suggest the 'RULE' is superfluous
>
>Comments anyone ?
>
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."
>
Received on Thu Nov 08 2001 - 13:41:54 CST
