Subject Re: [firebird-support] Re: Table with more than 100 index.
Author Ann W. Harrison
Dimitry Sibiryakov wrote:
> Ivan, sorting in Firebird has one vulnerability: it operates with
> uncompressed records, so if you have field VARCHAR(30000), filled with
> average 100 characters, sorting may be inefficient because every time
> during merge it will move 30000 bytes. Ordered reading won't.

Just to clarify, the sort in Firebird operates on the selected fields
uncompressed, not on the whole record.

Best regards,