tag:blogger.com,1999:blog-4323426512369830009.post1160201502924995405..comments2024-02-01T03:23:52.237-08:00Comments on Girlgeek's Oracle Blog: Delete vs. Truncate - graphicallyUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4323426512369830009.post-88498199510768090852011-06-24T06:29:18.912-07:002011-06-24T06:29:18.912-07:00Yes I already know the differences between both th...Yes I already know the differences between both these commands. And you have explained the efficiency of truncate statement so nicely by sharing the image and example with the help of which a beginner can easily understand it at the very first glance.sap support packshttp://www.panayainc.com/noreply@blogger.comtag:blogger.com,1999:blog-4323426512369830009.post-54808999269694930132010-01-08T11:30:11.437-08:002010-01-08T11:30:11.437-08:00let me share my experience with regard to the serv...let me share my experience with regard to the service of <a href="http://www.recoverytoolbox.com/how_to_recover_corrupted_database_in_ms_sql_server_7.html" rel="nofollow">sql data recovery</a>, it automatically eliminates data corruption issues in selected databasesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4323426512369830009.post-82393442220778543012008-11-01T11:52:00.000-07:002008-11-01T11:52:00.000-07:00Another point - I don't think TRUNCATE can be wrap...Another point - I don't think TRUNCATE can be wrapped in a transaction. So you might not always have the luxury of changing a DELETE FROM to a TRUNCATE. But point taken.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4323426512369830009.post-19160190075604232632008-10-03T12:01:00.000-07:002008-10-03T12:01:00.000-07:00Steve, The table that I truncated was the one that...Steve, <BR/>The table that I truncated was the one that had the million rows in it originally. Notice the insert <BR/>INSERT INTO T1_DEL (SELECT * FROM T1);<BR/>I then delete from t1_del and<BR/>truncate from t1. It was not an empty table.girlgeekhttps://www.blogger.com/profile/14087868237195091725noreply@blogger.comtag:blogger.com,1999:blog-4323426512369830009.post-23084926349021862962008-10-01T08:35:00.000-07:002008-10-01T08:35:00.000-07:00Um, of course truncating an *empty* table will be ...Um, of course truncating an *empty* table will be faster than deleting records ... You need to do <BR/><BR/> 1) insert <BR/> 2) delete <BR/> 3) insert <BR/> 4) truncate<BR/><BR/>and <I>then</I> you can compare delete versus truncate times.<BR/><BR/>Steve G.Blue Moon Sailorhttps://www.blogger.com/profile/13318892328806748469noreply@blogger.com