The index won't be used for the ORDER BY, but to resolve a JOIN or WHERE clause. ORDER BY is applied to the result set after the data has been selected. You can speed up the query by applying a WHERE condition so that the entire table isn't ordered or by using fewer fields instead of all of them.

>Am I correct in assuming that when you use SQL Select, the TOP syntax is not optimized for an index?
>
>I have a table MYORDERS with field ORDERNO that has index tag.
>
>When I try:
>
>

>select top 10 * from MYORDERS order by ORDERNO
>

>
>The query takes considerable time. I can sort of "see" that VFP selects all records and then selects 10 from the top. Is there a way to make this query run faster?
>
>Thank you.