Sean,

S> - Increase maximum key size to 1/4 page size from 253 bytes

S> - Add segment selectivity for multi-segment indexes, which improves the
S> choices that the optimizer will make in using the best indexes.

not to mention expression indexes, more efficient index compression,
automatic skipping of nulls...

S> - Improve the performance of index insert/update/deleted operations for
S> poor-selectivity indexes. (This is the reason that the restore time
S> dropped from 50 minutes to 26 minutes)

Not sure, as indexes are restored after the data. But I can confirm
better performance in scanning indexes with a large number of
duplicates (which of course will help insert/update/deletes as well,
but I have not timed that).

Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================