It will depend on a number of things. First of all the size of the indexes
(# leaf blocks) and the clustering factors.
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: breitliw_at_centrexcc.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Mar 26 2003 - 19:28:39 CST
