Gary Benade wrote:

> 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?

It's not strictly a good thing to do - diddling the system tables can
lead to unhappiness - but that particular update works and is
appropriate for your problem. If I were you, I'd make the change, then
backup and restore the database again, to be sure everything is really OK.

Regards,


Ann