Re: Delete fast

From: <mccmx_at_hotmail.com>
Date: 27 Jun 2006 07:51:28 -0700
Message-ID: <1151419888.628980.77370@y41g2000cwy.googlegroups.com>

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

Do you have indexes on that table...? try temporarily dropping the indexes. This should drastically decrease the amount of rollback data that is generated and therefore the redo that goes with it.

If there are a large number of composite indexes on this table this should speed things up considerably.

Good Luck

Matt Received on Tue Jun 27 2006 - 09:51:28 CDT