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