>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!
Actually, the ORDER BY clause operates on the result set, so the existance of a tag on LastName in the original table isn't a help - a temporary index must be created against the resultset, which becomes disconnected from the original table unless it can be processed as a filtered view, in which case, there will be a noticable delay in navigating the resultant cursor.