>>I am testing a SQL 2005 linked server. Works Ok but very slow. Is there something to do with indexes? Do I need to configure LS to use indexes? I did not find any property to set. Any idea?
>
>Check Optimizing Distributed Queries and Configuring OLE DB Providers for Distributed Queries in BOL

In BOL it says:

Using the indexes of the OLE DB provider has performance benefits only when the index and table rowsets are on the same computer as the instance of SQL Server. Therefore, the Index AS Access Path option should be set only if the data source is on the same computer as SQL Server.

Does that mean if my tables are on a different computer then SQL Server there is no way to take advantage of VFP indexes?