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