>>We use VFP 5.0a on a TCP/IP network under NT 4.0.
>>
>>Our VFP data resides on the server. When the user accesses a table with a conditional index tag (index tag type on type for type="C"), does the ENTIRE table move across the network to the users local computer, or just the records contained in the index?
>>
>>Denis Schuette
>>McElhaney Cattle Co.
>
>From what I understand, only the relevant portions of the
index are moved over the wire, and then only the records as they are needed.
In a query, indexes that contain a filter (for clause) are not used for optimization. The entire table is scanned, or a non-filtered regular index on "type" (bad choice of field name - reserved word) would be used.