Le 19/02/13 08:41, ml600f a écrit :

> Maybe Firebird 3.0 does better optimizations.
>

I'm not sure
range queries are not very efficient under Firebird, may be we need
another kind of indices instead of B-Tree for that, such as R-Tree, or
bi directionnal indices, but it would need a lot of work and it is not
planned for Firebird 3.0

using equality is now the only good way to have some good performance
under Firebird