Subject turn index on by manipulating rdb$indices
Author Gary Benade
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?