>I am working on a VFP 6.0 project that has 3 tables that are in SQLsvr 7.0 and the project accesses them thru remote views. Another programmer brought up the issue of building indexes on the views and using the rushmore technology to optimize access. To make a long story short this exposed a grey area in my knowledge about what is taking place with remote views. I was under the impression that the DBC in VFP had little effect and that SQLsvr was the main player in this situation. I tried researching this issue and could never find what I thought I was looking.
>Thanks in advance
>Bruce

You can index a view, local or remote, so long as the BUFFERING value is set correctly when you create the index:

CURSORSETPROP("BUFFERING", 3)
INDEX ON Name TAG Name
CURSORSETPROP("BUFFERING", 5)

Like local views, you have to create indexes on remote views on-the-fly. In other words, the index are not stored in the DBC. So, store your data in SQL Server, pull over just the records you need with VFP, and index them as appropriate before manipulating them.