Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Deletes without rollback
"paddy_nyr" <mpprpp_at_yahoo.com> wrote in message
news:c6tm1u$ga6qb$1_at_ID-197123.news.uni-berlin.de...
>
> "stevie" <steviehaston_at_hotmail.com> wrote in message
> news:4092f6be.0404300028.56140086_at_posting.google.com...
> > Hi
> >
> > I'm trying to find the fastest way to delete about 6 million records
> > from a table based on an exists condition with another table.
> >
> > Delete from ORIGINAL O where not exists
> > (select K.ID, K.AMID from KEEP K where K.ID = O.ID and K.AMID =
> > O.AMID)
> >
> > This takes a long time (~2hrs).
> >
> > I thought I would turn of rollback, since I don't care about this
> > operation being recoverable, with 'alter table ORIGINAL nologging' but
> > I still see lots of activity in the rollback activity.
> >
> > Can anyone shed any light on this situation or provide any tips on
> > improving the performance ?
> >
> > TIA
> > Stevie
>
> Modify your exists statement to
>
>
Delete from ORIGINAL O where not exists
(select 1 from KEEP K where K.ID = O.ID and K.AMID =
O.AMID)
Received on Fri Apr 30 2004 - 09:03:27 CDT