Subject Re: [ib-support] Speed of indexes
Author Joe Martinez
> Before starting to add multible records set your indexes inactive;
>
> ALTER INDEX name INACTIVE;
>
> then when finished set your indexes active
>
> ALTER INDEX name ACTIVE;

I'm assuming here that those inserts, then, won't be indexed at the time of the
insert?

Once you set the index back to ACTIVE, does it then automatically go back and
re-build the index for the inserted records?

Thanks,
Joe