>Hi,
>
>>how can I do it with view?
>
>As Sergey said, you can index the view. However, this only works when row buffering is active. With table buffering, you first need to commit/revert any changes and switch to row buffering. After creating the index you can switch back to table buffering.
Which is why, as a rule, most of us have to think ahead and create these indexes early on, as soon as the view is opened, then trust Fox to keep them updated - which it does, perfectly, and I didn't notice any speed penalty.