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 LazyDBA home page