Submitted Questions

  • Drop Vs Truncate

    Which is faster, Drop or Truncate? Explain

    masthan

    • May 30th, 2017

    Truncate is faster compared to Drop

    Rajan

    • Mar 17th, 2017

    1. TRUNCATE is a DDL command whereas DELETE is a DML command. 2. TRUNCATE is much faster than DELETE. Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first, then del...