Pierre,

It will have to check the whole table in order to make an accurate determination. But 100k rows should be nice and fast if Rushmore is effectively employed.

Cheers,

Jim N

>Hi again !
>
>In a Select SQL statement, specifying TOP nExpr or PERCENT and having ORDER BY DESCending ... will the statement parse the whole table, then order by DESC then give out nExpr
>
>or
>
>will the statement parse the table UNTIL it has nExpr rows regardless it has not reached EOF and then order by DESC
>
>My table will be 100K rows and I would like to dish out only nExpr (i.e: 200) of the latest entries.
>
>TIA
>
>Pierre Richard