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 |
