Re: need help tuning a very large delete

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

insert into temp dump Select from master where it does NOT match stage,
then
truncate master,
load back into master from temp dump?

If you can afford the period where master is not available.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam