>>Do you think I can use another method ?
>
>regular sql stmt sorted descending by field, then select top 10 from there? don't think it would be any faster.
Fastest way I've found is to index/set order to Field, SKIP n records,
get boundvalue, then SELECT WHERE Field > boundvalue
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.