Stored outline internals

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