mysql 比较两个表数据优化问题

Answer 1

// acc_id 加索引
SELECT accinfo_id FROM acc_accinfo acc

WHERE acc.`is_delete` = 1 AND  acc_id NOT in (
    SELECT  acc_id FROM acc_circulate_setting where area_id = 1  AND is_delete = 1 
    );
    
 // 或者分2步查   

Answer 2

Is the accinfo_id of acc_accinfo not indexed