> First is cheaper - the system retrieves only one record. Distinct has
> the advantage of letting you know if you've made a bad assumption about
> your data. Any aggregate function will also work and might be more
> reasonable than arbitrarily accepting the first value.
>
> Regards,
>
>
> Ann

Ann,
SELECT FIRST 10 SKIP 10000000 FIELD1 FROM TABLE1 ORDER BY FIELD2
TABLE1 contains 40million records

Now can you give me a step by step of exactly what the egine does to give me
these 10 records?
I'm sure the engine does not traverse 10mill records )it responds far to
quickly to do that), so what are the exact mechanics of the call.
Thanks
Alan