Consider Table-a is having col1,col2,col3,col4 as columns.
unique index is created on col3 and col4
select col1 from table-a
where col3 > :value:
and col4 = :value:
will the above query use the full index in the tablespace scan?
Please help me on this.
Thanks in advance