Inge,
In these 2 cases, the indexes are used. Lookup 'Rushmore Optimization' in help to learn more about how it works...
>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!
Steve Gibson