How to use index

Dear all,

I have a beginner of oracle and recently I have a prob with using indexes. I have a table with 5 columns, with no primary key set in the table. An index has created for column 1. I have a sql which retrieve rows based on the indexed column:

select *
from my_table
where
column_1 in ('A','B','C')

bcoz I select columns which are not indexed, the index created for column 1 cannot used either. Pls suggest a way so that I can retrieve all columns, at the same time db will make use of my index in column 1.

Many many thanks if anyone can kindly help me. Received on Thu Nov 06 2003 - 03:46:30 CET