Re: Oracle 9i hints that are obsolete in 11gR2

  • From: Kim Berg Hansen <kibeha@xxxxxxxxx>
  • To: John Hurley <hurleyjohnb@xxxxxxxxx>
  • Date: Mon, 31 Mar 2014 11:24:23 +0200

Great link, thanks, John :-)

So RULE hint still works - sorry I said otherwise.
But the explanations by Maria also shows that there are many things that
may preclude the RULE hint from working in a particular statement.
Which also can explain why David feels that "RULE hint rarely seems to
enhance performance in 11g." ;-)


Regards


Kim Berg Hansen

http://dspsd.blogspot.com
kibeha@xxxxxxxxx
@kibeha


On Sun, Mar 30, 2014 at 9:10 PM, John Hurley <hurleyjohnb@xxxxxxxxx> wrote:

> Yes "not supported" does not mean yet removed totally ... yet ...
>
> Maria Colgan
> https://blogs.oracle.com/optimizer/entry/why_was_the_rule_hint
>
>
>

Other related posts: