> i run the same test with MSSQL and look to the queryplan.
> MSSQL does it like i expect, it use the index range of the combined index and
> skips all that isn´t needed. It is allways rather quick.
> Even a real range where ID BETWEEN 1 AND 3 is allways quick (few msec).
> My App works many year
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 an
Thank you for your answer,
i run the same test with MSSQL and look to the queryplan.
MSSQL does it like i expect, it use the index range of the combined index and
skips all that isn´t needed. It is allways rather quick.
Even a real range where ID BETWEEN 1 AND 3 is allways quick (few msec).
My