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


when tableA is truncated the insert takes a more reasonable time of some 3 minutes.

Whats the definitive answer as to why this happens?

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: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search for HWM (High water mark) in the forum / google.
Previous Topic: Mutating trigge Issue...
Next Topic: Need help in query for finding search results
Goto Forum:

Current Time: Sat Aug 19 11:59:27 CDT 2017

Total time taken to generate the page: 0.04794 seconds