>>The all processing is done on workstation (WS) regardless if you're accessing VFP tables directly or through ODBC/ADO. If your query is not Rushmore optimizable, than the whole table has to be transfered to WS for processing. If query is optimizable, than first appropriate part of index(es) will be transferes to WS to determine what records to return and only requested records will be transfered to WS.
>>
>
>Hi Sergey,
>
>Thanks for the quick reply. In the Options under Tools I have "Rushmore Optimization" checked off. In all the EXEs I have "SET OPTIMIZE ON". Is this all that is required?
>
>Mike

No! You have to know HOW to use Rushmore - construct the proper indexes, code the proper queries etc.