Mike Yearwood
Toronto, Ontario, Canada
Hi
IMO (without testing right now), scan for examines the indexes to build a bitmap and navigates to the first record. Subsequent navigation uses the existing bitmap.
VFP Query examines the indexes and builds the bitmap. If you use the readwrite clause, it then creates a cursor and navigates through the records, dumping the records into the cursor. You'd then have to scan etc.
>Hi
>
>Which is faster a Scan for expression or a VFP Query?
>
>Thanks
>
>Colin Northway
Previous
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