Subject Index Bug
Author Sandeep
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.



Software Developer