Answered Questions

  • Which one is faster DELETE/TRUNCATE? Why?

    Harishankar Sahu

    • Nov 24th, 2017

    Truncate is faster. Because, its a DDL. So, no rollback information is stored. Truncate also does not consider integrity constraints; while delete does.


    • Sep 7th, 2016

    DELETE is a Safe mode of operation as it can be ROLLBACKed whereas TRUNCATE is Faster operation but cannot be ROLLBACKed.
    DELETE can be Few Records based on WHERE Clause while the TRUNCATE is a Full operation.