各位大虾:在执行这条语句的时候挺快:select qf_ivr_old.mobile from qf_ivr,qf_ivr_old where qf_ivr.mobile=qf_ivr_old.mobile但一执行删除时候:
delete qf_ivr where mobile in(select qf_ivr_old.mobile from qf_ivr,qf_ivr_old where qf_ivr.mobile=qf_ivr_old.mobile)比较慢,各位有什么好的方法,优化一下,谢谢
delete qf_ivr where mobile in(select qf_ivr_old.mobile from qf_ivr,qf_ivr_old where qf_ivr.mobile=qf_ivr_old.mobile)比较慢,各位有什么好的方法,优化一下,谢谢
select qf_ivr_old.mobile from qf_ivr,qf_ivr_old where qf_ivr.mobile=qf_ivr_old.mobile有多少数据量select count(*) from qf_ivr 有多少数据量。索引是什么?