Re: need help tuning a very large delete

Just in case you haven't got enough ways to try... here is 1 more suggestion to test/try...

Note: It would be nice to know the size of the tables in Megs/Gigs instead of records.

And the other suggestions would probably be better 1st tries... but worth testing/trying next might be:

Export with a where clause (assuming 8i or newer) what you want to keep to a local disk (separate physical disk than where the table is stored) on the server, trunc the table, disable/drop constraints/indexes/triggers, import the data, and re-enable/create constraints/indexes/triggers.

-- 
"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
news:1efdad5b.0309171145.77216dac_at_posting.google.com...


> Stage Table has 17 million records with Delete_column = 'Y';

>

> MAster has 27 million records.

>

> so I need to

> delete from master

> where master.pk = stage.pk

> and stage.pk = 'Y';

>

> i tried writing a 'create table as' with a 'not exists' and was

> running for 8 hours. killed it. didnt even go to 'killed' status which

> means the DML hadnt even started it.

>

> I tried doing the following: but cant get the outer join right. Is

> that faster than a minus?

>

> any ideas?