Subject Re: [firebird-support] Re: Bad indexes - expected 7 encountered 5 - Classic
Author Ann W. Harrison
will.honor wrote:

> I never delete from the tables that are affected by the corruption.
> I do however perform frequent updates on foreign key/indexed fields
> which may change the field to one value and then back again. Would
> this do the same as a delete/insert in the index?

Yes - updating an indexed field causes the old index entry to be
deleted.... Hmmm.