Hi All

This is the second time in about 6 months that my client is experiencing
corruptions

The following is extracted from the log ...
Index 10 is corrupt (missing entries) in table ORDTRN (144)
Index 13 is corrupt (missing entries) in table ORDTRN (144)
Index 14 is corrupt (missing entries) in table ORDTRN (144)
Index 15 is corrupt (missing entries) in table ORDTRN (144)

1. The index name I find in RDB$INDICES using
RDB$INDEX_NAME ,RDB$RELATION_NAME ,RDB$INDEX_ID
Am I looking in the right system table to locate the index name?
2. Are the entries missing in the index or in ORDTRN?
3. Does (144) mean the number of missing entries
4. Any ideas on why this should be happening on the db and how to minimise
the risk of this happening in the future.


Thanks
Regards Cao