Re: Best way to delete million records

From: <xhoster_at_gmail.com>
Date: 30 Jun 2008 16:49:13 GMT
Message-ID: <20080630124917.642$Qx@newsreader.com>


fefe78 <peppo_at_puppurnazzi.com> wrote:
> The table is indexed, and this is a one time procedure.

What is it indexed on?

> After this will be scheduled a job to daily delete old records.

Given this, I doubt that all 43 million rows need to be deleted in a single atomic transaction. If that is the case, breaking it into smaller transactions could prevent causing havoc with the undo.

> In some forums I red that drop indexes and ricreate them after deletion,
> could be a good solution.

If the indexes are important, then dropping them will effectively "stop service", which you say is not allowed.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.
Received on Mon Jun 30 2008 - 11:49:13 CDT

Original text of this message