5
Reply

Which one is faster delete/truncate? Why?

sakshi goyal

sakshi goyal

May 10, 2012
4.3k
0

    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.

    Ritesh Singh
    July 26, 2016
    0

    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

    Rahul Prajapat
    June 10, 2015
    0

    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

    Rupesh Kahane
    October 04, 2014
    0

    Truncate is faster because it delete data at a time.

    Munesh Sharma
    April 14, 2014
    0

    Truncate is faster than delete as Delete has to perform two step's at database level for deleting but truncate has only one step.

    Parin Turakhia
    May 15, 2012
    0