1.Previous
3.Next

much slower than TRUNCATE
* You can undo the operation of removing records by using the ROLLBACK command
* DELETE requires a shared table lock
* Triggers fire
* DELETE can be used in the case of: database link
* DELETE returns the number of records deleted
* Transaction log - DELETE needs to read records, check constraints, update block, update indexes, and generate redo / undo. All of this takes time, hence it takes time much longer than with TRUNCATE
* reduces performance during execution - each record in

1.Previous
3.Next