Organizational Research By

Surprising Reserch Topic

boostr.in questions - Question:how to Compare and contrast TRUNCATE and DELETE for a table?


 

Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces few rollback data. The delete command, on the other hand, is a DML operation, which will produce rollback data and thus take longer to complete.
 

asked Sep 13, 2013 in ORACLE by rajesh
edited Sep 12, 2013
0 votes
31 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...