一个关于update 的问题急！！！！！！！！！！！

[zhao2815]

update ent_info set yjhmment =
(
select
case when (sxze<=5000000 and (ent_info.CAPITALAMOUNT <=1000
OR ent_info.LASTYEARSALE <=3000) )
then '01'
else '02'
end
from dhsxze
where dhsxze.customerid = ent_info.customerid
) where 1＝1;
这个update中进行了关联表更新字段，但跑起来的时候非常慢 请问各位大虾 问题出在哪

[dawugui]

update ent_info 
set yjhmment = 
case when (sxze <=5000000 and (CAPITALAMOUNT <=1000 OR LASTYEARSALE <=3000) ) 
then '01' 
else  '02' 
end 
from ent_info,dhsxze 
where ent_info.customerid = dhsxze.customerid 

[天-笑]

update ent_info set yjhmment = 
case when (sxze <=5000000 and (ent_info.CAPITALAMOUNT <=1000 OR ent_info.LASTYEARSALE <=3000) ) then '01' 
else  '02' end 
from ent_info inner join dhsxze on dhsxze.customerid = ent_info.customerid 

[linux_ch]

建立索引

[hyqwan11112]

update ent_info 
set yjhmment = 
case when (sxze <=5000000 and (CAPITALAMOUNT <=1000 OR LASTYEARSALE <=3000) ) 
then '01' 
else  '02' 
end 
from ent_info,dhsxze 
where ent_info.customerid = dhsxze.customerid

[zhao2815]

这里不加括号会报语法错误，
因为这个sql 是写在存储过程中的，不加where 1=1在跑批的时候会有中断的
对全表进行更新 还是很慢