|Subject||Re: [firebird-support] Re: Bad indexes - expected 7 encountered 5 - Classic|
|Author||Ann W. Harrison|
> I never delete from the tables that are affected by the corruption.Yes - updating an indexed field causes the old index entry to be
> 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?