Oracle High Performance Tuning for 9i and 10g
|
| < 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 > |
|