>>>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.

>Fortunately, you don't. Can't hurt, but you don't have to.
>The index will automatically reindex on the requery.
>Tablerevert seems to act like on any other buffered table in this regard.

I went back and checked. The index needs to be closed is transactions are used. If the index is not closed Error 1548 occurs:

Table "alias" has one or more non-structural indexes open. Please close them and retry the Begin Transaction.