Re: Oracle 9i hints that are obsolete in 11gR2
From: Kim Berg Hansen <kibeha_at_gmail.com>
Date: Mon, 31 Mar 2014 11:24:23 +0200
Message-ID: <CA+S=qd0mona76ZP4t6npY5BcA6BAB79M-+FC+NjyjKjhuwFq+A_at_mail.gmail.com>
Great link, thanks, John :-)
Date: Mon, 31 Mar 2014 11:24:23 +0200
Message-ID: <CA+S=qd0mona76ZP4t6npY5BcA6BAB79M-+FC+NjyjKjhuwFq+A_at_mail.gmail.com>
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_at_gmail.com
_at_kibeha
On Sun, Mar 30, 2014 at 9:10 PM, John Hurley <hurleyjohnb_at_yahoo.com> wrote:
> Yes "not supported" does not mean yet removed totally ... yet ...
>
> Maria Colgan
> https://blogs.oracle.com/optimizer/entry/why_was_the_rule_hint
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 31 2014 - 11:24:23 CEST