>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!
Any index that EXACTLY MATCHES the expression on the left side will be used to optimize the record fetching - whether this makes the query faster - or slower. I'm not sure about sorting.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)