+1 vote
in PL/SQL by
Compare And Contrast Truncate And Delete For A Table ?

1 Answer

0 votes
by

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 a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

Related questions

+2 votes
asked Jan 15, 2022 in Sql by GeorgeBell
+1 vote
asked Jan 2 in MariaDB by john ganales
...