Re: Delete fast

Hi,

Yes, the table has indexes and they are quite big according to the table size.
Finally we have decided to run the script that delete blocks of 100.000 rows
each commit and count on the slow progress. All the alternatives mean to copy
the table to a new table and recreate indexes, for this table we don't have enough
space to do it, so time to accomplish it is the only problem.

Thanks anyway,

> 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 - 11:08:08 CDT