Re: Delete fast

From: jmartin <jorge.jose.martin_at_cgi.com>
Date: 27 Jun 2006 05:45:35 -0700
Message-ID: <1151412334.822837.245110@x69g2000cwx.googlegroups.com>

Hi,

The table has a thousand of millions of records, and I just need to delete 150 millions.
We have tryed the delete 100.000 records at a time and it is extremelly slow.

Anthing that can help?

Thanks in advance,

nirav ha escrito:

> IF you dont care about restoring the table, THEN you can think of
> truncating it also. (do you have a recent backup of that table which is
> sufficient in case of recovery?-in that case you can consider truncate.
>
> using nologging with delete will not do any good.
> Nirav
Received on Tue Jun 27 2006 - 07:45:35 CDT