Re: Delete whole table in one go versus batches

From: J.P. <jp_boileau_at_yahoo.com>
Date: 20 Aug 2002 05:16:13 -0700
Message-ID: <7e388bc3.0208200416.2cb9c414@posting.google.com>

Personally... If a user walks up to me and asks me to truncate a table instead of him/her deleting all the 1+ million rows from it... I'll pay close attention to his need!

Anytime someone mentions deleting 1+ million rows... My ears spring up.

Richard Foote <Richard.Foote_at_bigpond.com> wrote in message news:<3D61C0AC.FCD332E1_at_bigpond.com>...
> Hi Ender,
>
> OK, got the scenario. Here's my solution.
>
> set timing on

[snip] Received on Tue Aug 20 2002 - 07:16:13 CDT

This message: [ Message body ]
Next message: Kenneth: "Re: Select Distinct over Database Link"
Previous message: Dusan Bolek: "Re: Experience"
In reply to: Richard Foote: "Re: Delete whole table in one go versus batches"
Next in thread: Thomas Kyte: "Re: Delete whole table in one go versus batches"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US