RE: Re: how to get oracle to ignore an index

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 6 Feb 2004 14:13:37 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E9369F@qtiexch2.qgraph.com>

Perhaps that is one case, but I just tried this:

SELECT /*+ index(pm partmaster_partno) */ * FROM partmaster pm;

...where "partmaster" is an 8400 block table, and "partmaster_partno" is a 2-segment unique index, and Oracle still correctly chooses the FTS, even though I hinted to use an index.

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----

From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Friday, February 06, 2004 2:04 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Re: how to get oracle to ignore an index

Ryan

Here is the way I look at the issue you raise. Hints are coded as comments, not a part of the SQL statement. If a hint has bad syntax, Oracle does not error out, but treats the mangled hint as a comment. If the hint refers to an index that doesn't exist, Oracle does not error out. That is what I think is meant by saying that Oracle can ignore a hint if it chooses to.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Feb 06 2004 - 14:13:37 CST