Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateNotes → Maximum number of indices in different Firebird versions
Firebird Home Firebird Home Prev: Passing NULL to UDFs in Firebird 2Firebird Documentation IndexUp: NotesNext: Document History

Maximum number of indices in different Firebird versions

Between Firebird 1.0 and 2.0 there have been quite a few changes to the maximum number of indices per database table. The table below sums them all up.

Table A.2. Max. indices per table in Firebird 1.0 – 2.0

Page size Firebird version(s)
1.0, 1.0.2 1.0.3 1.5.x 2.0.x
1 col 2 cols 3 cols 1 col 2 cols 3 cols 1 col 2 cols 3 cols 1 col 2 cols 3 cols
1024 62 50 41 62 50 41 62 50 41 50 35 27
2048 65 65 65 126 101 84 126 101 84 101 72 56
4096 65 65 65 254 203 169 254 203 169 203 145 113
8192 65 65 65 510 408 340 257 257 257 408 291 227
16384 65 65 65 1022 818 681 257 257 257 818 584 454


Prev: Passing NULL to UDFs in Firebird 2Firebird Documentation IndexUp: NotesNext: Document History
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateNotes → Maximum number of indices in different Firebird versions