massive delete

Hi:

    Which is the fastest way to delete many rows (over 400k-800k) from a big table (over 7.000.000 rows) frequently. I'm doing it now with a cursor to the table, committing every 'N' rows.

Will performance get increased with bigger rollback segments and reducing committing?

excuse my poor english

thanks

    Jorge Received on Thu Sep 23 1999 - 06:37:30 CDT