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.


Cheers,
Thomas