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