Gerhardus Geldenhuis wrote:

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

Every time a record is added the index is updated. By disabling the indexes you
save this for a one time hit when the inserts are complete.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further