left join 查询缓慢

EXPLAIN
select a.id
FROM oa_attachment a
LEFT JOIN sys_user u ON u.id = a.create_by
LEFT JOIN sys_user v ON v.id = a.writer
where a.del_flag=0

 

 

优化统一u.id ， a.create_by，v.id ，a.writer的编码