Re: No logging during delete

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 20 Nov 2005 02:10:54 +0100
Message-ID: <437fcd1f$0$6821$ba620e4c@news.skynet.be>

<prasath.rao_at_gmail.com> wrote in message news:1132161022.634589.167020_at_g49g2000cwa.googlegroups.com...
> Hi,
>
> I am interested in knowing how to delete millions of records
> periodically from a table efficiently.
>
> Can we use the nologging option on the table?
>
> I am NOT looking for solutions which copy the records across a
> temporary table, truncating the original table, renaming etc.
>
> Thanks,
> Prasath.
>

To speed up the deletes, it might help to disable or drop all indexes, triggers, constraints, ... prior to the operation.

Matthias Received on Sat Nov 19 2005 - 19:10:54 CST