I agree with you if we talk about a little amount of data but if you put 1
million records to a table with 7 million records you'll see the diffrence.

I saw :)

----- Original Message -----
From: "ian" <ian.mellor@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Tuesday, June 19, 2001 12:40 PM
Subject: Re: [ib-support] Speed of indexes


> "F. Ugurtan Erdem" wrote:
> >
> > 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;
> >
> Im guessing there is an optimum in this - eg in a table with 7 million
> records where rebuilding an index takes time and tends to cause the
> server a certain amount of hassle the gain for the person
> adding/deleting a chunk of records has to be compared to the loss for
> all other users?
>
> yours,
> Ian
>
> 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/
>