>>>>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.
If it's not broken, fix it until it is.
My Blog