>>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.
Insanity: Doing the same thing over and over and expecting different results.