DELETE TABLE is a logged operation, it is a slow process. Delete can be roll back operation
TRUNCATE TABLE deletes all the rows, but it won't log the deletion, conquently it is fast process.
TRUNCATE TABLE can't be roll back operation
No comments:
Post a Comment