Updating Millions of Records Efficiently | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Updating Millions of Records Efficiently

I 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.
Ashish.
Kindly don’t duplicate post.
I’ve block this one, and I suggest to continue in Developer section. Luis Martin
Moderator
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?
I suggesthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5727
Could a moderator please lock the other two? ———————–
–Frank
http://www.insidesql.de
———————–
]]>