Subject Database corrupt - how to tell which index to rebuild
Author Bob Murdoch
I just experienced my semi-yearly database corruption on an FB 1.5
30GB database running on W2K3 server. I just finished running gfix,
and have a number of entries in Firebird.log that look like this:

Index 4 is corrupt on page 3853736 in table XRDS501 (303)

From previous experience, I know that I can alter the index
inactive/active to rebuild it. However, how do I know exactly which
index is "Index 4"?


Bob M..