一条SQL语句求优化

[iammac]

两个表
T1（2万条数据） 和 T2（一百万条数据）

目的是比对T1和T2的ID字段或者是Name字段，只要有一个能匹配上就在T1设置flag并且把T2的某字段（例如location）赋给T1。

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID 
   or
   T1.Name=T2.Name

这个语句可行吗？我执行了大概快半个小时了还是没有结果。
分别对两个表的ID和Name设置了索引。
以有没有办法让结果更快一点？谢谢

[喜-喜]

ID 和 Name 分两次写吧！上面写的那种感觉别扭...

[xuam]

Update T1
set flag=1,
Location = T2.Location
FROM T1,T2
where (T1.ID = T2.ID) or (T1.Name=T2.Name)

[dearbinge]

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID 

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Name

OR关键字会使索引失效，建议分成两条语句 --- 个人见解，楼主测试一下

[fcuandy]

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID 

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Name
WHERE T1.flag = 0

[Rotel-刘志东]

[Quote=引用 2 楼 xuam 的回复:]
Update T1
set flag=1,
Location = T2.Location
FROM T1,T2
where (T1.ID = T2.ID) or (T1.Name=T2.Name)
[/Quote]
or的效率是比较低的。

[--小F--]

[Quote=引用 4 楼 fcuandy 的回复:]
SQL code
Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID

Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Nam……
[/Quote]

同意FC的

[andy_liucj]

[Quote=引用 4 楼 fcuandy 的回复:]
SQL code
Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID

Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Nam……
[/Quote]
+1

[liuweicai772]

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID 

Update T1
set flag=1,
    Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Name
WHERE T1.flag = 0

[zxjnew]

不要写or， 分成两句sql来写！！
Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.ID = T2.ID

Update T1
set flag=1,
Location = T2.Location
FROM T1
inner join T2
on T1.Name=T2.Name
WHERE T1.flag = 0