Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need help tuning a very large delete
Ryan Gaffuri wrote:
>
> 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?
Standard stuff: disable indexes, triggers etc
Other options: Generate some rowid ranges and run multiple deletes in parallel
hth
connor
-- ========================= Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue"Received on Thu Sep 18 2003 - 05:30:15 CDT