Which is faster.. TRuncate or DROP

• Prashant Pandey

  SSChasing Mays

  Points: 657

  More actions

  October 31, 2007 at 9:50 am

  #180728

  I have a question. Will use of TRUNCATE TABLE and then DROP TABLE be faster and use less resources than just the DROP TABLE statement?

  I got this doubt because Truncate will not log delete of each individual row.

  What u people think ..??? which will be faster.??

  Thanks

  Thanks,
  Prashant

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  October 31, 2007 at 10:31 am

  #747165

  Neither the truncate nor the table drop will record individual row deletes.

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 31, 2007 at 10:44 am

  #747172

  I guess, internally TRUNCATE is more or less like DROP....CREATE statements, so obviously the second one should be faster....:cool:

  --Ramesh
  

  ---