Strictly speaking, hint rule still works even on 12.1, but it is not supported since 10.1 Best regards, Sayan Malakshinov Senior Oracle performance tuning engineer PSBANK http://orasql.org 30.03.2014 21:38 пользователь "Kim Berg Hansen" <kibeha@xxxxxxxxx> написал: > Rule based optimizer stopped working from version 10.1. > RULE as OPTIMIZER_MODE gives warning and RULE hint is ignored as there is > no longer a rule based optimizer that can follow the old optimizer "rules" > ;-) > > http://docs.oracle.com/cd/B14117_01/server.101/b10763/compat.htm#sthref318 > > > > Regards > > > Kim Berg Hansen > > http://dspsd.blogspot.com > kibeha@xxxxxxxxx > @kibeha > > > > > > On Sun, Mar 30, 2014 at 5:24 PM, David Roberts < > big.dave.roberts@xxxxxxxxxxxxxx> wrote: > >> I haven't done any investigation to to determine why, but the RULE hint >> rarely seems to enhance performance in 11g. >> >> In a previous role we had a standing rule that rule hints would be >> removed by default when upgrading from 9i or 10g to 11g. >> >> Dave >> >> >> On Thu, Mar 27, 2014 at 6:32 PM, Bheemsen Aitha <baitha@xxxxxxxxxxxxxxxxx >> > wrote: >> >>> Thanks to everyone for your great inputs. Your replies definitely help >>> me as a starting point. >>> >>> >>> >>> Thanks >>> >>> *Bheem Aitha* >>> >>> >>> >>> *From:* Dominic Brooks [mailto:dombrooks@xxxxxxxxxxx] >>> *Sent:* Thursday, March 27, 2014 2:56 AM >>> *To:* Hemant-K.Chitale@xxxxxx >>> *Cc:* Bheemsen Aitha; ORACLE-L >>> *Subject:* Re: Oracle 9i hints that are obsolete in 11gR2 >>> >>> >>> >>> Also see V$SQL_HINT for a list of hints. >>> >>> I don't think it tells you which are deprecated unless that's reflected >>> in PROPERTY. >>> >>> >>> >>> Interestingly, there is no PARALLEL hint only SHARED which is listed as >>> the inverse of NOPARALLEL/NO_PARALLEL >>> >>> Cheers, >>> >>> Dominic >>> >>> >>> >>> Sent from my iPhone >>> >>> >>> >> >> >