Hi, Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions. If I do a select * from emp and select * from emp1 now, which one should execute faster and why?

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

TRUNCATE TRUNCATE does not return number of deleted rows. TRUNCATE TABLE always locks the table and page but not each row. DELETE When we have to use DELETE Command then the data deleted can be ...

Mohammad Mansoor

• Feb 24th, 2016

Truncate and Drop commands Rollback is not possible for Table, whereas Delete Command we rollback the Data

Answer Question  Select Best Answer