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>
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