SQL Server Performance Forum – Threads Archive
Updating Millions of Records EfficientlyI have two tables in MS SQL SERVER, as following 1. Table1 with 1000 Records with three fields a, b and c 2. Table2 with 13+ Million Records with three fields x, a, b, c, d, e and f Now i want to update the fields Table2.b and Table2.c with Table1.b and Table1.c respectively by field "a" of Table1 and Table2. Currently if i am using a join condition in update statement as given below:
"update Table2 set b = Table1.b, c = Table1.c from Table1, Table2
where Table1.a = Table2.a" This update is taking many hours to do update. Can u please suggest if i have any other options to update the table much faster than this? Thanks in Advance.
Kindly don’t duplicate post.
I’ve block this one, and I suggest to continue in Developer section. Luis Martin
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
In which of your three threads should we now continue?
Could a moderator please lock the other two? ———————–