RE: Re: how to get oracle to ignore an index
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2004 14:13:37 -0600
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@xxxxxxxxxxxx Quad/Tech International, Sussex, WI USA
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx]
Sent: Friday, February 06, 2004 2:04 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@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
-----------------------------------------------------------------
Other related posts:
