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,...
> > So, the limit is either 255 or more likely 127. Drop some indexes.
> Any
> > table with more than 100 indexes suggests bad design.
>
>
>
> On Sat, Dec 29, 2012 at 2:19 PM, Mark Rotteveel <mark@...>
> wrote:
>
> Are you sure?

No. And probably the error was from Access or something else. Helen's
answer is better.

According to

> http://www.firebirdsql.org/en/firebird-technical-specifications/ it
> 65535 indices per table (which BTW is a hell of a lot).
>

I stand by my assertion that even 1/655 of that is too many indexes.

Cheers,

Ann

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

[Non-text portions of this message have been removed]