"select in" does not use indexes. Use EXISTS() instead.
On 18/02/2015 11:25, martin_gorr...@yahoo.es [firebird-support] wrote:
Hi;
I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4
Ghz - 8 GB ram).
If I run this query it goes very very fast and returns 84 records:
P
Hi;
I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4 Ghz - 8
GB ram).
If I run this query it goes very very fast and returns 84 records:
Preparing query: select distinct "PROC" from "GEST" where ("GEST"."FSAL"
between '20080801' and '20080812') order by "PROC"
Pr
