General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Not a peculiar question at all. In fact, VFP selects all the records then dumps all but the top 99. So it's not a very efficient method, it's just a bit more convenient than having to pull out the top 99 yourself.
>
>>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
Thanks Josh!
That's what I was afraid of!!!
BB
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only