Dennis wrote:

> Delay on first open of indexes.
>
>
>
> There is a table where has 170000 records, using an index with 3 keys using
> and 'order by' in the script. No outer joins (seems simple)!
>
>
>
> Question 1
>
> The first query delays about 15 seconds, if we try to execute it again the
> same it takes about 1 second. How can we face the first delay?
>
>
>

Probably because on the second run the data are already on cache.

But, the first thing...

Tell us:

FB version and show us the query...

> Thank you in advance.
>
> Dennis
>
>
>

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br