| Subject | Re: [ib-support] Speed of indexes | 
|---|---|
| Author | Joe Martinez | 
| Post date | 2001-06-19T08:46:18Z | 
> Before starting to add multible records set your indexes inactive;I'm assuming here that those inserts, then, won't be indexed at the time of the
>
> ALTER INDEX name INACTIVE;
>
> then when finished set your indexes active
>
> ALTER INDEX name ACTIVE;
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