I have a table with two indices

index1 on fieldA, fieldB
index2 on fieldA, fieldC

fieldB is varchar (20) and fieldC is numeric (18, 0)

when I do a select statement like

select * from tableA
where fieldA = :val1 and
fieldC = :val2

I expect it to use index2, but for some reason it uses index1. I need the
statement to use index2 as I'm using them in stor proc, and this
behaviour makes stor proc too slow.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz