Subject Re: [IBO] turn index on by manipulating rdb$indices
Author Lester Caine
Gary Benade wrote:

> I have PK indices that are inactive for some reason, probably a dodgy
> restore. To activate them I need to drop the PK and recreate it, but to do
> this automatically is quite a major undertaking.
> I noticed that if I directly change the RDB$INDEX_INACTIVE value of the
> index in question from 1 to 0 the index rebuilds and everything is 100%.
> Is this a safe thing to do, and are there problems I should watch out for?

That one is best asked on firebird-support !
Not sure many of us here would delve that deep in the guts ;)

Lester Caine
L.S.Caine Electronic Services