Subject Re: [firebird-support] Re: RES: Version number
Author Thomas Steinmaurer
>> This is also possible, but only if you migrate not to the official
>> v2.5.2 release but to some earlier snapshot build.
>> Dmitry
>> One question Dimitry. We have some quite large databases and cannot do a
> backup restore cycle. Also rebuild indices may take so much time.
> What kind of indices has to be rebuilded?
> All? Compound indices? Compound indices with nullable fields?

I would say nullable compound indices, but Dmitry might have the
ultimate answer. ;-)

> If not doing backup/restore, rebuild PK indices is complicated.

The following used to work rebuilding a PK index:

alter index <pk_index> active;

The trick is to set the index active, even if it is already active. ;-)

With regards,
Thomas Steinmaurer