| < Day Day Up > |
|
The DDL TRUNCATE command is faster than using the DELETE command when deleting all the rows from a table. The TRUNCATE command automatically commits and does not create any log entries or rollback. The obvious problem with TRUNCATE is that an error cannot be undone.
| < Day Day Up > |
|