If all else is equal, I have the impression the index with the lower object# is being used, but I'm not certain. If all else is equal it doesn't matter.
The same considerations apply for the selection of a join index.
At 04:03 PM 3/26/2003 -0800, you wrote:
if I have a table with columns a,b,c,d,e and there are two concat indexes on this table with a,b,c and a,b,d
in a query which is using column a in where clause which index will be used ?
will this plan change if the table is joined with ( driving table )
-ak
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).