>I want to scan a table from bottom to top. Currently, I am using a while loop for that. Is there any faster way like scan?
>
>Thank you,
>Ali
Ali
If you're scanning it with an index set, just reverse the order of the index.
Update:
And, if you're not setting an index, set one - it will be faster than a DO WHILE loop.
Regards,
Jim