InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Compare And Contrast Truncate And Delete For A Table. |
|
Answer» 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. 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. |
|