>>I have a parameterized view that is used in a couple of different forms. The first time that the view is queried after a form is opened, it is extremely slow (8-10 seconds). After that, when changing the parameters and REQUERYing, the view returns results instantaneously. The view is only slow the first time. All the fields that the view filters and joins on are indexed. Does anybody know what causes this behavior?
>Erik,
>
>Is it possible that you are setting deleted off in one of the form's events? Do you ahve an index on deleted() for the tables involved with the view?
>
>If you set deleted off in a fomr method then t is on the first time the view gets populated and then it is off. This will affect the speed of teh query if there is no index on deleted.

The tables all have indexes on deleted() but it is probably irrelevant, because I don't change DELETED() in my code.