top button
Flag Notify
    Connect to us
      Site Registration

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
1,400 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 LinkedIn 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.

...