Hi!
After opening a remote view you can create temporary index by issuing
INDEX ON expression TAG tagname
But it may be better to use another remote view with one record instead of LOCATE.

>We are creating a remote view to an Oracle table. This view contains several thousand records. We need to perform a LOCATE to find a record in this view.
>
>It appears that the locate in the view is slow. Is there a way to create a CDX tag or IDX index on this view? We need to update this view and send the changes back to Oracle.
>
>How can we speed up the LOCATE?