easy index question

Easy question on indexes.

I have 2 indexes on a table:

index1 on columns col1,col2,col3
index2 on column col3

if I remove col3 from index1 and then use col1,col2 and col3 in a SQL statement where clause (in that order) will both index1 and index2 be used?
Will the search be more efficient if the three columns are in a single index (the table is rarely modified).

Hope the above makes sense. Any help on this gratefully received.

regards

Richard Received on Thu Jun 24 1999 - 06:05:07 CDT