Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete whole table in one go versus batches
Hi Ender,
Love to hear what those various reasons are ...
Love to hear just one.
Richard
Ender Wiggin wrote:
>
> Are there any performance gains to delete rows in batches versus one delete
> statement if I don't cause the rollback segments extend ? Thnx
>
> Rows > .5 million
>
> PS> Cannot use truncate for various reasons...
Received on Mon Aug 19 2002 - 22:09:07 CDT