Firebird Documentation Index → Firebird 2.0.6 Release Notes → Enhancements to Indexing |
Table of Contents
New and reworked index code is very fast and tolerant of large numbers of duplicates. The old aggregate key length limit of 252 bytes is removed. Now the limit depends on page size: the maximum size of the key in bytes is 1/4 of the page size (512 on 2048, 1024 on 4096, etc.)
A 40-bit record number is included on “non leaf-level pages” and duplicates (key entries) are sorted by this number.
Firebird Documentation Index → Firebird 2.0.6 Release Notes → Enhancements to Indexing |