>>>>An index on pkfield ought to do it.
>>>>
>>>>What data type is pkfield?
>>>
>>>Correction. The field is Numeric(6,0) but there is an index tag on this field. Yet, Rushmore is not used.
>>
>>Try
>>

>>select * from myTable where pkfield IN (select top 100 pkfield from myTable order by pkfield DESC)

>
>Nope. This does not work either.

What about just

select top 100 pkField from myTable ORDER BY PkField DESC ?

Also ORDER BY is not guaranteed to be optimizable. It's VFP engine that decides if it wants to optimize it or not.