Hi All!

I have a peculiar question regarding TOP clause in SQL Select.
How does VFP perform this task: (let's say I want the top 99 records)
1. VFP fetches all appropiate records, orders them and deletes unwanted ones on the end above 99, or
2. VFP uses the index of ordered field in base table, and fetches only the records that fall under 99 according to the index.

TIA

BB