求SQL语句帮优化


update iptv_billinfobeforelist t
set t.del_flg = '1', t.rank = '100', t.reason = '删除PPV欢乐体验用户'
where t.del_flg = '0'
and t.datesource = 'PPV_ZTE'
and t.login_name in (select t.login_name from delete_ppv_users t) 执行了1小时了。。索引也建了,求优化。

update iptv_billinfobeforelist
set del_flg = '1', rank = '100', reason = '删除PPV欢乐体验用户'
from iptv_billinfobeforelist t
inner join delete_ppv_users d on t.login_name = d.login_name
where t.del_flg = '0'
and t.datesource = 'PPV_ZTE'


把 2个表的索引都告诉我



Copyright © 2009-2011 All Rights Reserved.