Hi Bernhart,

I don't see any setting that could explain such big query duration difference. Check what else may be different, like location of temp files, e.t.c.

>Sergey and others...
>
>Part1
>In a *.prg i have with the same requery and the same Index and the same tables
>6 Seconds for a requery.
>*!* Rushmore optimization level for table datesfiltred: none
>*!* Using index tag Delrec to rushmore optimize table etats
>*!* Rushmore optimization level for table etats: full
>*!* Rushmore optimization level for table resident: none
>*!* Joining table etats and table datesfiltred using temp index
>*!* Joining table resident and intermediate result using temp index
>
>Display status to file give http://www.Amline.be/Test.txt
>
>Part2
>In my application with same table and same code and same index I have 0.6 seconds !
>Environment <>
>
>*!* Rushmore optimization level for intermediate result: none
>*!* Using index tag Delrec to rushmore optimize table etats
>*!* Rushmore optimization level for table etats: full
>*!* Rushmore optimization level for table resident: none
>*!* Joining intermediate result and table etats using temp index
>*!* Joining table resident and intermediate result using temp index
>
>Display status to file give http://www.Amline.be/Test1.txt
>
>4 set are different.
>
>I think that the buffer are also different.
>
>What can do it ?
>