Home » SQL & PL/SQL » SQL & PL/SQL » Slow Insert after Delete
Slow Insert after Delete [message #185968] Fri, 04 August 2006 09:38 Go to next message
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
Re: Slow Insert after Delete [message #185969 is a reply to message #185968] Fri, 04 August 2006 09:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search for HWM (High water mark) in the forum / google.
Previous Topic: Trigger Execution failed
Next Topic: Function Help
Goto Forum:
  


Current Time: Thu Dec 08 06:30:45 CST 2016

Total time taken to generate the page: 0.07834 seconds