Subject Re[4]: [ib-support] Strange query problem
Author Daniel Rail

> (my reply was besides the ORDER BY stuff, but...)

> An in-memory sort (order by) after reading all rows is faster than
> reading the rows in index-order... That is, IF you want all rows.
> An indexed read can be faster if you just want to have the first
> couple of rows of your resultset and not the complete result.
> Somewhere there should be a point where things tip the scale...

Point well taken and totally agree.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (