|Subject||RE: [firebird-support] Database corrupt - how to tell which index to rebuild|
> -----Original Message-----which
> From: Dmitry Yemanov [mailto:dimitr@...]
> Sent: Monday, July 17, 2006 10:38 AM
> "Bob Murdoch" <mailgroups@...> wrote:
> > 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
> > index is "Index 4"?Thanks Dmitry.
> select RDB$INDEX_NAME
> from RDB$INDICES
> where RDB$RELATION_NAME = 'XRDS501' and RDB$INDEX_ID = 4
What if the index is the primary key? Can I alter inactive/active?