Is there a better way to empty a large table in database than using DELETE state...

smallwei 12:30 pm on October 22, 2009 | Answers: 1    
Tags: database (51), db2, delete (84), mysql (35), oracle (138), sql (43), sql server (2), table (16), tip (8)

Rate Knowledge:

 Loading ...

• smallwei 12:33 pm on October 22, 2009
  

  Use TRUNCATE statement.
  - DELETE writes to the log, where as TRUNCATE does not.
  - TRUNCATE table removes all rows from a table, but the table structure and its columns, constraints, indexes etc., remains as it is.