While you can still use local indexes, that should not be your primary focus. When the data is in VFP, it is local. Issue a USE, and bang, you have your data. With SQL-Server, you need to pull records down from the server, over the wire, to you client workstation. This is where your attention needs to be, minimzing the number of records the client works with.

Typically, folks have some sort of query form that brings down a set of records to work with.

>I am just upsized an application to use SQL Server 7 and am using remote views on the data. Previously I was using compound indexes on local tables, what is the best way to replace this functionality on a remote view? I don't want to create indexes on the fly due to the large amount of data involved? Any ideas?
>
>Thanks,
>Doug