>Can anyone tell me if you can create an index on a Remote View? If so what is the syntax.
Only after the view has been USEd. It won't persist, so you'd have to recreate it when you need it. If it's table buffered, it will have to be switched to row buffering first, then indexed, then switched back.
When the remote view is closed, the index is erased (it's a temp file)
That said, the syntax is the same. e.g.
Use myremoteview
Index On myfield Tag myfield
HTH
Insanity: Doing the same thing over and over and expecting different results.