Google+ Followers

Sunday, August 31, 2014

Difference Between Truncate and Delete

This is one of the most important questions generally asked in the interview.

  • Truncate releases allocated memory but Delete operation doesn't release allocated memory.
  • Truncate is faster than Delete because it perform the operation on Table but delete performs operation on each row.

I hope you enjoyed the article don't forget to share on Facebook. Please leave your comments below if there are any questions.

No comments: