top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

WHICH ONE WILL BE FASTER IN SQL SERVER: INSERTING ONE MILLION ROWS OF DATA, OR UPDATING ONE MILLION ROWS OF DATA?

+3 votes
893 views
WHICH ONE WILL BE FASTER IN SQL SERVER: INSERTING ONE MILLION ROWS OF DATA, OR UPDATING ONE MILLION ROWS OF DATA?
posted Mar 31, 2014 by Prachi Agarwal

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button
There is no comparison of these two events, however I am assuming your question to be  In SQL, is UPDATE always faster than DELETE+INSERT?

Please check the following link it should be helpful for you -
http://stackoverflow.com/questions/1271641/in-sql-is-update-always-faster-than-deleteinsert/

If you differ on point of view please feel free to get back to us.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...