Indexes and Where clauses

In order to ensure that an index gets used in a query, does the column is position one of the index have to be in the where clause?

For instance. If I have an index like the following: INDEX_NAME COLUMN_NAME COLUMN_POSITION ----------- ----------- ---------------

INDEX1       KEY_1          1
INDEX1       KEY_2          2

Will INDEX1 be used if only KEY_2 is specified in the where clause?

Thanks. Received on Thu Jul 31 1997 - 00:00:00 CDT