如何优化性能(速度)

[junweili]

select wo,Product_Name,status into line_Q1_fct1 from SF_Cp_Detail where wo ='MAO1002021' 时运行速度很快

但我把此wo记录放在line_Q1_fct1_temp时,运行以下SQL语句会很慢

select wo,Product_Name,status into line_Q1_fct1 from SF_Cp_Detail where wo IN (SELECT wo FROM line_Q1_fct1_temp)


因为我有好几个wo在line_Q1_fct1_temp，谁能帮我优化一下以上语句

[--小F--]

select
 a.wo,a.Product_Name,a.status 
into
 line_Q1_fct1 
from
 SF_Cp_Detail a  join line_Q1_fct1_temp b 
on
 a.wo=b.wo 

[zs621]

select wo,Product_Name,status into line_Q1_fct1 from SF_Cp_Detail A
INNER JOIN line_Q1_fct1_temp B ON A.WO=B.WO

[zs621]

select wo,Product_Name,status into line_Q1_fct1 from SF_Cp_Detail A
INNER JOIN line_Q1_fct1_temp B ON A.WO=B.WO

WO列上加索引

[cd731107]

select a.wo,a.Product_Name,a.status 
into line_Q1_fct1 
from SF_Cp_Detail a ,line_Q1_fct1_temp b 
where a.wo=b.wo 

[kingtiy]

select a.wo,Product_Name,status into line_Q1_fct1 from SF_Cp_Detail 
 a join  (SELECT wo FROM line_Q1_fct1_temp)  b
 on a.wo=b.wo

[xineryixin]

select wo,Product_Name,status
into line_Q1_fct1
from SF_Cp_Detail a
where exists(SELECT 1FROM line_Q1_fct1_temp where wo = a.wo)

[唐诗三百首]

也可能是查询当时有锁争(Lock latch)的情况,可考虑加 nolock.

select a.wo,a.Product_Name,a.status 
into line_Q1_fct1 
from SF_Cp_Detail (nolock) a
inner join line_Q1_fct1_temp (nolock) b
on a.wo=b.wo