RE: fast loading

Posted in 2001

Sinha, Niraj — Thu, 4 Jan 2001 11:52:14 -0500 — source: Informix-list mailing list archive (1991-1998)

you can disable constraints and indexes. Look up the manual -----Original Message----- From: triggerfish2001@hotmail.com [mailto:triggerfish2001@hotmail.com] Sent: Thursday, January 04, 2001 7:51 AM To: informix-list@iiug.org Subject: fast loading Hi, I am using insert into table2 select * from table1. Is there a way to temporarily disable indicies on table2 when doing the above. The objective is to increase the speed of loading. TIA.