请问除了加索引以外，还可以如何优化 sql 呢？

需要查询出总数、成功数和失败数渲染到页面，43W 条数据中查询出 600 多条需要查询 9s 以上。后来给所有 where 以及 order by 的字段加上了索引，用 EXPLAIN 检查发现创建了临时表和全表扫描，遂把 distinct 去掉，但效果还是不理想。想请教下还应该如何进行优化呢？
初始 sql 如下：
SELECT
t.business_no AS businessNo,
t.service_type AS serviceType,
(
SELECT
count(d.datagram_id)
FROM
t_issue_plat_datagram d
WHERE
t.business_no = d.business_no
) AS limitCount,
(
SELECT
count(b.datagram_id)
FROM
t_issue_plat_datagram b
WHERE
t.business_no = b.business_no
AND b.batch_status = '2'
) AS sucessCount,
(
SELECT
count(c.datagram_id)
FROM
t_issue_plat_datagram c
WHERE
t.business_no = c.business_no
AND c.batch_status = '3'
) AS falseCount
FROM
(
SELECT DISTINCT
g.business_no,
g.service_type
FROM
t_issue_plat_datagram g
WHERE
1 = 1
ORDER BY
g.updated_date DESC
) t
修改后的 sql:
SELECT
t.business_no AS businessNo,
t.service_type AS serviceType,
(
SELECT
count(d.datagram_id)
FROM
t_issue_plat_datagram d
WHERE
t.business_no = d.business_no
) AS limitCount,
(
SELECT
count(b.datagram_id)
FROM
t_issue_plat_datagram b
WHERE
t.business_no = b.business_no
AND b.batch_status = '2'
) AS sucessCount,
(
SELECT
count(c.datagram_id)
FROM
t_issue_plat_datagram c
WHERE
t.business_no = c.business_no
AND c.batch_status = '3'
) AS falseCount
FROM
t_issue_plat_datagram t
GROUP BY
t.business_no
ORDER BY
t.updated_date