Subject Re: [firebird-support] Does anyone know what the error too many indexes in table TMP%#MAU@ means
Author Mark Rotteveel
On 29-12-2012 19:33, Ann Harrison wrote:
> Firebird has a limit on the number of indexes that can be created on a
> table, because the index identifier is a byte. The system tables in
> Firebird were designed in the early 1980's when every byte was precious.
> So, the limit is either 255 or more likely 127. Drop some indexes. Any
> table with more than 100 indexes suggests bad design.

Are you sure? According to it
65535 indices per table (which BTW is a hell of a lot).

There used to be a limit in index key size of 252 bytes, but now it is
1/4 of the page size.

Mark Rotteveel