What is the difference between truncate and delete? How would a full table scan behave after?
- 1 Answers
- 642 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vishwa Natri
DELETE removes rows from a table, leaving space for them to be reused. TRUNCATE also removes all rows from a table but it does not leave any space for reuse; instead, it deallocates the space occupied by the table. After a full table scan on a DELETE operation, the block will be marked as used until new data is inserted, while after a TRUNCATE, the blocks become available immediately for reuse.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
