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.