Hi Jason

Can something like

select
first 10
skip ((select count (fieldA) from tableA) - 20)
* from tableA

be exploited to speed up the last operation in table

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz