Fabio,

In addition to Ed,

Like Ed daid, when the the query is (partially or full) optimizable the optimizable part is downloaded to the client. However it would be a big mistake
to index your tables that your queries are fully optimizable.

For example, if your table has 1.000.000 records, of which are a few deleted records, and you would index the table on DELETED() the whole index tag of deleted() (1.000.000 index nodes) is downloaded. Esspecially on a WAN this might take forever. It is much better to download the optimizable part, and let the VFP engine filter out the rest by scanning the results for non optimizable filters.

Conclusion. Index your table wisely. Use high-selective indexes (indexes in which the occurance of an indexvalue is low) in stead of low selective ones (indexes that contains large numbers on the same index value).

Walter,


>
>Suppose I have a WAN and I want to access a DBF file that is held by a remote machine. Suppose that I have a drive letter (Z:) mapped to this location and I raise the following commands:
>
>use Z:\Customers
>select Name from Customers where ID = "001"
>
>What comes through the wire? Does Visual FoxPro tries to optimize the download of the data or has the table to be completely downloaded in order to the processing be done?
>
>Thanks in advance!