Re: How can I optimize a query on two indexed columns?

select col1, col2
from tab1
where col1||'' = 'x' and col2 = 'y'

will force optimizer to use col2 index

Patrick Received on Mon Apr 20 1998 - 08:25:59 CDT