What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
- 1 Answers
- 652 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kiran Kumari
Truncate and Delete are used to remove data from a table, but they have differences in behavior. Truncate quickly sets the number of rows in a table to zero and releases the space occupied by the table. It does not generate redo or undo logs, making it faster than Delete. Delete removes specific rows based on a WHERE clause and generates redo and undo logs. A full table scan will behave similarly after both operations. Both Truncate and Delete do not support rolling back.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
