Re: mass deletes

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 9 May 2005 12:13:25 +0200
Message-ID: <427f37c5$0$1411$ba620e4c@news.skynet.be>

"Andreas Boehm" <andreas_at_andiboehm.de> wrote in message news:427F36AE.6070905_at_andiboehm.de...
> Hello *.*,
>
> is there a possibility to tune mass deleted on a table, that is linked to
> by many other tables using foreign keys. These tables have about 100-200
> times more records than it, not null links.
> One delete yielding 19000 deleted of the 92000 records lasts about 1.5
> hours.
> Any suggestions?
>
> regards,
> Andreas
>

you could do the deletes in parallel : search r-the docs for PARALLEL DML
instead of deleting lots of rows from a table, you could create a new one with CREATE TABLE ... AS SELECT * FROM OLDTABLE WHERE ..., then rename the new table afterwards.

Matthias Received on Mon May 09 2005 - 05:13:25 CDT