>HI Tim,
>Thank you for the tips. One question. If the RBS were increased enough to allow me to delete all rows in a single command, would this improve the time it takes to delete all rows ?
>
>Thank you for your help,
>Christian

It is common to have a HUGE RBS and assign
a specific transaction to this rollback segement..This way only one
RBS is used thus helping with some processing.

I think it looks like:

SET TRANSACTION USE ROLLBACK SEGMENT large_rs1;
DELETE blah blah;

If the RBS is too small you will likely get rollback errors during thye execution of the command.



HTH