Also, if you have multiple hints and have a syntax error somewhere, not just the malformed hint but also everything following is ignored. At 10:52 AM 2/6/2004, you wrote: >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. > > > >----- Original Message ----- >From: <ryan.gaffuri@xxxxxxx> >To: <oracle-l@xxxxxxxxxxxxx> >Sent: Friday, February 06, 2004 5:40 PM >Subject: Re: Re: how to get oracle to ignore an index > > >I havent played around with the 10053 trace. No time. I was hoping for >something simple at the db level. > >i mean i put in a hint and the plan doesnt change. oracle can choose to >ignore hints. > > > >---------------------------------------------------------------- >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 >----------------------------------------------------------------- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com ---------------------------------------------------------------- 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 -----------------------------------------------------------------