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 Walker wrote:
> Some additional information. Just out of curiousity I deleted
> everything from the database except the effected table (all generators,
> tables, view, UDF's, procedures, etc). Then I swept the database.
> After doing that I was able to create the index in question.

Oh, how odd. If you just delete stuff without sweeping, do you still
get the error? How big is the database?