Tuesday, November 17, 2009

Which is faster Truncate/Delete

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

No comments:

Post a Comment