SET ORDER, SET FILTER

Also, the amount of memory you have available, probably less in the application, than when run alone from a prg.

Vlad

>Hello everybody,
>
> Can anybody tell me which SET can affect query speed (I know SET
> Optimize)? May be there are some other SET that can slow down query?
> I'm asking this because when I run my query alone in prg, it takes around
> 60 seconds for first time and then around 38 seconds for subsequent runs.
> But when I run the same prg within application, the first run time is 115
> secs and the subsequent calls takes 68-70 secs. Obviously, something
> slows down this query.