Maya Opperman wrote:

>
>> ... If
>> you think your indexes are causing problems as they age, you could just
>> rebuild some of them each night rather than doing a full restore of
>> the database.
>
> How do you mean rebuild exactly? Dropping and re-creating them, or
> something else?

Deactivate and reactivate will do it.

> And will that fix an index if it is corrupt?

Some index corruptions keep the indexes from being deactivated, but
if you're seeing that, then you've found a bug in the Firebird index
code. It's possible to have an index that's reported as corrupt
that reflects the result of a crash in the middle of an index change.
Those "corruptions" may reduce the efficiency of an index, but should
not affect the results of an index lookup. Between the two - benign
results of crashes and corruptions that keep an index from being
dropped or deactivated - are a number of results of index code bugs,
several of which Vlad has fixed over the past year or two. And yes,
deactivating and reactivating will fix all of those.


Best regards,


Ann