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...