sql update query for bulk data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql update query for bulk data

Author

Topic

shishirnaik55
Starting Member

2 Posts

Posted - 2010-03-26 : 03:55:29

to all experts
please give some expert opinion about my problem
my db table1 is having 4 columns
c1,numeric,10(size)
c2,text
c3,text
c4,char(50)
table 2
c1,char,50
c2,numeric,10
c3,numeric,10

i am running update query
create index indx_t1 on t1(c1,c4)
update t1 set t1.c4=t2.c1 from t1,t2 where t1.c1 between t2.c2 and t2.c3

my problem is number of records is 20 lakh

it is taking hell lot of time around 5 hours
am i doing anything wrong, or there any other way to do this
please help me out

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-26 : 11:24:05

are you using sql 2005?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

shishirnaik55
Starting Member

2 Posts

Posted - 2010-03-27 : 01:05:23

[quote]Originally posted by visakh16

are you using sql 2005?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

no i amusing sql 2000

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources