Re: Delete whole table in one go versus batches

Coughs, not the owner of the table, access is given to insert/select/update/delete for the table. So unless my dear DBA grants me to drop any table, I am kind of stuck...

Richard Foote wrote:

> 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...