Hi
Why is it faster to update without indexes and then adding or activating
them afterwards than by updating/adding with indexes active.

Groete
Gerhardus

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: 18 June 2001 16:58
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Speed of indexes
>
>
> At 04:41 PM 18-06-01 +0200, you wrote:
>
> >Is there anyway to speed-up inserts with a table that has indexes?
>
> Yes: deactivate them.
>
>
> >Btw All of my data is generated like this(value=random(x)). My
> reasoning is
> >that it won't matter whether a char field contains numbers or letters.
>
> The casting involved might introduce overhead in huge batches. Ann?
>
> -- HB
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
> 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/
>
>