Slow Insert after Delete [message #185968] |
Fri, 04 August 2006 09:38  |
charliebankes
Messages: 11 Registered: June 2006
|
Junior Member |
|
|
After deleting all 2 million odd rows from a table an insert statement to insert another 2 million odd rows from another table takes some 3 hours
delete from tableA;
insert into tableA select * from tableB;
(Same is true even after COMMIT between delete and insert)
However
when tableA is truncated the insert takes a more reasonable time of some 3 minutes.
Whats the definitive answer as to why this happens?
Thanks
|
|
|
|