>>>>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.
Check this thread
How does TOP work? Thread #
1362672
If it's not broken, fix it until it is.
My Blog