Hello,

on a big table (more than 10 000 000 rows) i need to do a query
like

select
ID
from
Hash
where
X1 > 10 and
X1 < 20 and
X2 >40 and
X2 < 60 and
X3 > 12 and
X3 < 22 and
X4 > 33 and
X4 < 44 and
X5 > 89 and
X5 < 99;

i try everything on firebird (mostly the plan), puting an index on each
column, the best i have
is 300 ms to retrieve the data.

now using simply SQLIte3 with Rtree index on the same amount of row the
result is given in 0 ms !!

is their any way out to do the same thing using Firebird ?

thanks you by advance
stéphane