If deleting all rows, use truncate <table>
Jorge <cafelito_at_---NO---SPAM---yahoo.com> wrote in message
news:7sd3m6$6fi$1_at_diana.bcn.ttd.net...
> 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 - 08:09:36 CDT
