| Subject | turn index on by manipulating rdb$indices |
|---|---|
| Author | Gary Benade |
| Post date | 2005-06-15T20:38:05Z |
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 in RDB$INDICES
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?
TIA
Gary
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 in RDB$INDICES
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?
TIA
Gary