Which one is faster delete/truncate? Why?
sakshi goyal
Truncante is performs better than delete because when you delete the records from the database, database has to perform 2 actions.1.delete from the database2.write the deleted records into "rollback" segments.But incase of "Truncate" the second activity is not required.
Truncate is faster Because when we use DELETE, all data get copied into the ROLLBACK TABLESPACE first, then delete operation get performed. This is opposite as truncate so truncate is faster
Truncate is faster because it delete data at a time.
Truncate is faster than delete as Delete has to perform two step's at database level for deleting but truncate has only one step.