Hi both index are used also take a look to SYS(3054) function.

>I have a table called myTable in a database called myData. myTable has a structural (primary) index called ID on field ID, and another (regular) index called LASTNAME on field LASTNAME. In this SQL statememt:
>SELECT * FROM myTable WHERE id='0125'
>is the ID index automatically used, or do I have to specifically specify that I'd like it to use the ID index?
>How about:
>SELECT * FROM myTable WHERE id>'0125' ORDER BY LASTNAME :
>both ID & LASTNAME index automatically used?
>Thanks all!