Re: Slow deleting records

Since truncate is a ddl command and not dml, it can not be rolled back. In fact, it has an implied commit which will cause any uncommitted work to be committed when you issue the command. Oh, and the person executing the truncate command must have alter rights to the table.

"Kevin P. Fleming" wrote:
>
> >I have a table that only has 15000+ records but when I try to delete all
 the
> >records it takes forever. We benched marked it to about 15 minutes per
 1000
> >records. The only thing I can think that may cause this is that this table
> >has a long datatype field but most records are very small.
> >
> >Any ideas would be appreciated.
> >
> >
>
> If you really want to delete _ALL_ the records, use the TRUNCATE command.
> It's instant, and can recover the storage allocated to the table as well if
> you like.
  Received on Tue Nov 03 1998 - 00:00:00 CST