Using VFP6 SP4.

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?

Thanks,

Jerryt