30.4.11

DIFF BETWEEN TRUNCATE AND DELETE

----- DIFF BETWEEN TRUNCATE AND DELETE


1. TRUNCATE WILL DELETE THE ENTIRE TABLE @ A STRETCH DELETE WILL DELETE EACH RECORD
2. NO LOGGING IN TRUNCATE ... LOGGING DELETE
3. PROCESS IS TOO FAST AND WE CAN RECOVER THE DATA IN TRUNCATE


Cheers,
Venkatesan Prabu .J
Head - www.kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/
at

3 comments:

  1. Eran SmithJune 1, 2011 at 12:54 AM

    This comment has been removed by the author.

    ReplyDelete
  2. AnonymousJuly 4, 2011 at 10:38 PM

    I think your post is very confusing and the second point is completely wrong.

    Check http://vadivel.blogspot.com/2004/06/delete-vs-truncate-statement.html where I found the differences between Delete and Truncate to be more meaningful.

    ReplyDelete
  3. AnonymousJuly 20, 2011 at 1:24 AM

    I think you meant 'we can't recover data in truncate' instead of 'we can recover data'.

    ReplyDelete