Subject Re: [firebird-support] Err -663 "Too many keys defined for index" while trying to create single field index on table with 4 records..
Author Ann W. Harrison
Brenden,

When your database is in the state where it's returning the error,
would you try

select max (rdb$index_id) from rdb$indices
where rdb$relation_name = 'REP_PARSEDLOGS';

I suspect that we're returning the wrong message and that the problem is
that - over time - you've used as many index definitions for that table
as the system considers sane...

Regards,


Ann