Re: Emptying Tables

Posted in 1998

Karl & Betty Schendel — Wed, 18 Mar 1998 12:12:06 GMT — source: Informix-list mailing list archive (1991-1998)

On Tue, 17 Mar 1998 16:33:37 -0500, bala peddi <bala.peddi@fmr.com> wrote: > No , ,,,,, BTW Informix Delete is Much faster than Ingres initialize. Bullshit. MODIFY TO TRUNCATED is as fast as the underlying filesystem can create a new file. >BALA > >Herb Blacker wrote: > >> Is there an easy way to quickly empty a table, other than either >> "delete from xxx where 1=1;" or dropping the table and recreating it? >> I'm an old Ingres DBA, and there used to be an 'initialize' SQL >> command to quickly empty a table.