Re: SQL Deletes without rollback

From: paddy_nyr <mpprpp_at_yahoo.com>
Date: Fri, 30 Apr 2004 10:02:29 -0400
Message-ID: <c6tm1u$ga6qb$1@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 Received on Fri Apr 30 2004 - 09:02:29 CDT