nearly all the articles i read are either by tom kyte, written by people on this list, or recommended by people on this list. i think it was kyte who wrote it. I could be wrong. I read alot of material. > > From: Jared.Still@xxxxxxxxxxx > Date: 2004/02/06 Fri PM 01:50:33 EST > 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 > > > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------