And, you can't get much more reliable than Jonathan.... -----Original Message----- From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx] Sent: Friday, February 06, 2004 1:51 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Re: how to get oracle to ignore an index You may have seen it in an article. The reliability of information depends on the source. Jared <ryan.gaffuri@xxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 02/06/2004 10:28 AM Please respond to oracle-l =20 To: oracle-l@xxxxxxxxxxxxx cc:=20 Subject: Re: Re: how to get oracle to ignore an index i cant reproduce the data for you. its internal. I tested it repeatedly. = I=20 was very careful about the hint.=20 select /*+ index(<index_name>) */=20 select /*+ index(<table> <index_name>) */ Tried it repeatedly. I've seen it before. Sorry, I cant show you the = data,=20 etc... I could have swarn I read in the docs that hints are just=20 directives and oracle does not have to use them? I cant find it right = now.=20 Am I wrong? I'm pretty sure I have seen that several times.=20 >=20 > From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx> > Date: 2004/02/06 Fri PM 12:52:47 EST > To: <oracle-l@xxxxxxxxxxxxx> > Subject: Re: Re: how to get oracle to ignore an index >=20 >=20 > Why do you think that Oracle can choose to ignore hints ? > Do you have reproducible example that proves the point ? >=20 > Bear in mind that a comment that looks like > a hint is only a hint if it is used correctly in > the right context. >=20 >=20 > Regards >=20 > Jonathan Lewis > http://www.jlcomp.demon.co.uk ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------