How to use index
From: Ken <wingkei_leung_at_hotmail.com>
Date: 5 Nov 2003 18:46:30 -0800
Message-ID: <63029411.0311051846.55f7406e_at_posting.google.com>
Date: 5 Nov 2003 18:46:30 -0800
Message-ID: <63029411.0311051846.55f7406e_at_posting.google.com>
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 *
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
from my_table
where
column_1 in ('A','B','C')
Many many thanks if anyone can kindly help me. Received on Thu Nov 06 2003 - 03:46:30 CET