Firebird Documentation IndexFirebird 2.0.6 Release Notes → Enhancements to Indexing
Firebird Home Firebird Home Prev: Stored Procedure Language (PSQL)Firebird Documentation IndexUp: Firebird 2.0.6 Release NotesNext: Expression Indexes

Enhancements to Indexing

Table of Contents

252-byte index length limit is gone
Expression Indexes
Changes to Null keys handling
Improved Index Compression
Selectivity Maintenance per Segment
Firebird Index Structure from ODS11 Onward

252-byte index length limit is gone

A. Brinkman

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.

Prev: Stored Procedure Language (PSQL)Firebird Documentation IndexUp: Firebird 2.0.6 Release NotesNext: Expression Indexes
Firebird Documentation IndexFirebird 2.0.6 Release Notes → Enhancements to Indexing