Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3F698937.608F_at_yahoo.com>...
> 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
the slowdown is the sort. its huge.
Received on Thu Sep 18 2003 - 14:26:16 CDT
