Hi,

> (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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)