It will...


Best Regards,
Ganesh R
Everest Reporting Team
DID: +65-6215-8413
Tel: 215-8413
HP : +65-9067-8474



-----Original Message-----
From: K.P.SuresKumar [mailto:[Email Address Removed] Friday, May 30, 2003 1:57 PM
To: LazyDBA.com Discussion
Subject: Index use..........


Hello,

I have table with 3 columns, name call COL1, COL2 , COL3 and those
columns are primary key (composite). In this case I just want to confirm
if execute the following query, will it be use the index?

Select col2,col3
from test
where col1 = 22;

Thanks in advance,

K.SuresKumar.



--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page