Hi All, I have one simple query to update old code with new code, but there are estimated 3 million records inside the table and need to update more than 10 to 20 tables. I create index key but at the fist time always face time out problem. do you have any idea how to avoid time out connection. Query as : UPDATE Table1 SET Ccode = @newCode WHERE Ccode = @oldCode UPDATE Table2, 3, 4, .... Appreciate your kindly suggest !