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 > 

Категории