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
jmartin wrote:
> Hi,
>
> I have a table where I have to delete millions of records.
> Is threre any hint or trick to delete them faster?
>
> I have thought to do before
>
> ALTER TABLE mytable NOLOGGING;
>
> and after de delete to restore to LOGGING.
>
> Any clue.
>
> Thanks in advance,
Received on Tue Jun 27 2006 - 06:28:54 CDT
