Re: question on mass deletes

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 09 May 2005 07:32:29 -0700
Message-ID: <1115648910.123560@yasure>

Andreas Boehm wrote:

>
> 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

DDL?
DML?
Explain Plan?
Version?
Current optimizer statistics?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon May 09 2005 - 09:32:29 CDT