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