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



Government Jobs Opening


...