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
