Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Delete whole table in one go versus batches
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:03:23 CDT