How does Oracle use indexes?

From: <mmrw_at_cc.flinders.edu.au>
Date: Thu, 30 Sep 1993 06:45:20 GMT
Message-ID: <1993Sep30.064520.17984_at_frodo.cc.flinders.edu.au>


A vendor has supplied an application with the following three indexes on a table:-

Index1 uses columns col1, col2, col3, col4, col5, col6.
Index2 uses columns col1, col2, col3.  
Index3 uses columns col1, col2.

I think index2 and index3 are redundant. The vendor says no.

Surely Oracle can use index1 in any situation when only some of those leading columns are needed! Can anyone shed light on this problem?

Thanks,

	Rick Williams
	The Flinders University of South Australia.
Received on Thu Sep 30 1993 - 07:45:20 CET

Original text of this message