sql语句优化问题，求助

[code_apeman]

SELECT DATE(del_sendmsg_records.send_date) AS oneday,del_branchs.name AS del_branch_name, del_branchs.shortname AS del_branch_shortname, COUNT(*) AS number
FROM del_sendmsg_records
JOIN del_branchs
ON del_sendmsg_records.del_branch_id=del_branchs.id
WHERE del_sendmsg_records.sended=1
GROUP BY oneday,del_sendmsg_records.del_branch_id


这个应该怎么优化啊，目测是因为这个才慢WHERE del_sendmsg_records.sended=19（sendedtinyint(1) NOT NULL是否已发送，0未发送，1发送）应该怎么优化

[li498833284]

关联表的顺序换下 分组字段顺序换下 建立复合索引（sended del_branch_id） 试下吧 看有没有效果 正常应该是弄个统计表的

[code_apeman]

[Main_csdn_String]

设置表别名 你试一试