----- Original Message -----
From: "Joe Martinez" <joe@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, June 19, 2001 11:46 AM
Subject: Re: [ib-support] Speed of indexes


> > 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>