Difference between Truncate and Delete

Truncate is Data Dafanition Language.
Truncate command cannot be rollback.
When Table is deleted memory occupied is released and also water mark is adjusted.
Truncate is faster than Delete.
Delete is Data Manipulation Language.
Delete is slower than Truncate.
Delete command is rollback.
When Table is deleted memory occupied is not released and also water mark is not adjusted

No comments:

Post a Comment

Plz Share your comments...