Subject Re: [firebird-support] Database corrupt - how to tell which index to rebuild
Author Thomas Steinmaurer
Hello Helen,

>>>> What if the index is the primary key? Can I alter inactive/active?
>>> -- to deactivate it
>>> update rdb$indices
>>> set rdb$index_inactive = 3
>> Anything special with using 3 instead of 1? Or does it need to be a
>> value > 0?
> Something Dmitry told me recently: an 'inactive' flag of 3 is set by
> gbak restore when it can't activate an index for some reason, e.g.
> duplications in a unique index.
> If the flag is 3, then the engine will permit

Nice one. In some cases very useful.