I have a table with 80 million rows of data. I need to delete about 40 millions. I can do either
1. set a huge rollback segment and delete 40millions at once
or
2. run a procedure and delete 10000 rows at a time
Which is faster?
|
Results 1 to 10 of 15
Thread: delete 40million rowsThreaded View
|
Click Here to Expand Forum to Full Width |