Re: clear table fast ?

From: Ken Johnson <kenneth.johnson_at_juno.com>
Date: 1997/01/14
Message-ID: <01bc01ae$0e72c0b0$72110fcf@rmc2>#1/1

Use

        TRUNCATE TABLE YourTableName;
This will delete all the records in the table very quickly.

---

Ken Johnson <kenneth.johnson_at_juno.com>

axime <axime_at_ipf.de> wrote in article <32D9F376.41C6_at_ipf.de>...
> Hi !
>
> I need to remove all (~100.000) rows from a (temporary) table.
> What is the fastest way to do this? Is it possible to do something like
> a 'modify to truncated' in Ingres, i.e. without logging the
> transactions?
>
>
> TIA,
> Uwe
>
Received on Tue Jan 14 1997 - 00:00:00 CST