Subject RE: [firebird-support] Re: Corruption in Firebird Classic 1.5.3.4870
Author Bob Murdoch
Will,

> -----Original Message-----
> From: will.honor [mailto:will.honor@...]
> Sent: Friday, December 01, 2006 2:14 PM
>
> Thanks for the info. I have seen your previous posts and the
issues
> do look very similar. A question for you, do the indexes that go
> corrupt on you always seem to include at least one (usually more)
> foreign key with poor selectivity? I have been looking back through
> the logs on the various sites and this seems to be a common factor.

No, the most commonly troublesome table has only a PK and three
indices, none are unique.

Bob M..