>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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05