Delete fast

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:25:24 CDT