The best way is to make sure that the view is Rushmore optimizable. For instance, if your view does SELECT * FROM mytable WHERE LastName=?m.Last you should have the base table indexed on LastName. If the WHERE clause has UPPER(LastName)=?m.Last your index should be on UPPER(LastName).

>hi all
>
>im making an aplication in vfp 3.0 an have troubles with parametrized views, the trouble its that its take a lot of time to run
>i wanna ask if are any way to increase the speed of a view or better
>use queryes?
>
>the time take a lot when i use requery("myview")
>thanks in advance.
>A.M.G