Subject Optimization - Select Query
Author Luis Carlos Junges
Hi,

How does work the optimization of select queries on firebird.

I a query that retrieve the results in 8 seconds at the first time and in 1,2 seconds after 4 times.

The problem is that after some time it requires the 8~10 seconds again. It seems that after some time the optimization table (or whatever is) is deleted.

Someone known what exactly i can do to enable it permanently or this is not possible? Or even a link with the explanation f how does it work. I could not find it.



thanks






---
Luís Carlos Dill Junges ©

"A realidade de cada lugar e de cada época é uma alucinação coletiva."
Bloom, Howard


Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

[Non-text portions of this message have been removed]