>No, John. It wasn't about indexing of remote view. The idea is that when you use SELECT-SQL (even rushmored) VFP requires part of CDX file travels through network, because processing is on workstation- this is the difference from client-server when server processes everything (including indexes) on spot.

Yes, true. But if you grab the data through a remote view and do an index on the fly at the local workstation then you have the best of both worlds. Then again, if you use non-clustered indexes in SQL Server that put the data in the order you want maybe that *is* faster.