>Can anyone tell me if you can create an index on a Remote View? If so what is the syntax.

You can use the INDEX ON command to create a temporary index on views. I believe that you'll have to CLOSE INDEXES and recreate the index(es) when you do TABLEREVERTs and REQUERYs.