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 To: oracle-l@xxxxxxxxxxxxx cc: 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 was very careful about the hint. select /*+ index(<index_name>) */ select /*+ index(<table> <index_name>) */ Tried it repeatedly. I've seen it before. Sorry, I cant show you the data, etc... I could have swarn I read in the docs that hints are just directives and oracle does not have to use them? I cant find it right now. Am I wrong? I'm pretty sure I have seen that several times. > > 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 > > > Why do you think that Oracle can choose to ignore hints ? > Do you have reproducible example that proves the point ? > > Bear in mind that a comment that looks like > a hint is only a hint if it is used correctly in > the right context. > > > Regards > > 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 -----------------------------------------------------------------