>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?

Assuming that you want to scan in the reverse of the physical order

INDEX ON RECNO() DESCENDING  TAG rn OF Temp
SCAN 
...
ENDSCAN