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
http://www.firebirdsql.org/en/firebird-technical-specifications/ 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
--
Mark Rotteveel