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?

Regards,


Ann