Re: HELP! Deletes taking FOREVER

From: Andreas Breuer <breuer.andreas_at_gmx.de>
Date: Wed, 16 Jun 1999 15:46:32 +0200
Message-ID: <3767AAB8.B5FDC1BC@gmx.de>

Doug Cowles schrieb:

> Hi, I have a table with about 14,000 rows in it, and after watching a
> delete on the table
> hang, and hang, and hange again, I bounced the database, (after checking
> for blockers)

If you are sure you want to clear the table and are absolutely sure you won't need a rollback, why not clear the table by "brute force":

TRUNCATE TABLE mytable

Should clear very fast, because no rollback-data is stored...

Andreas Breuer Received on Wed Jun 16 1999 - 08:46:32 CDT