DB2 执行UPDATE语句超级慢
UPDATE TABLE1 t1 SET (t1.bdcdyh,t1.ywh)=(select t2.bdcdyh,t2.ywh from table2 t2 where t1.yxtbh=t2.yxtbh and t2.zddm is not null) where t1.yxtbh in (select t3.yxtbh from table3 t3 where t3.bdcdyh is not null and t3.zddm is not null and t3.ywh is not null and t3.qxdm='123456')
这条语句大概有10W的数据量,但是执行3个小时都执行不出来。有大神知道怎么解决吗,求救!