Truncate is faster than Delete
When a Delete operation is executed the data that needs to be deleteded is copied to Rollback table space first, that is the reason the data can be rolled back.
When Truncate is called the row data is completely removed, Hence Truncate is faster than delete
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment