哪位大神帮忙看下这段SQL怎么优化

Question

SELECT aa.area_id,aa.area_name,aa.order_service_server,aa.owner_id ser_id,bb.owner_id usr_id 
FROM gh_statement_three aa 
LEFT JOIN 
(SELECT area_id,owner_id 
FROM gh_statement_three 
where statistics_type='5' 
AND service_value > 1 
AND operation_date between cast('2021-01-01' as DATE) and cast('2021-06-01' as DATE) ) bb 
on aa.area_id=bb.area_id and aa.owner_id=bb.owner_id 
WHERE 1=1 
AND aa.statistics_type='1' 
AND aa.order_service_server IS NOT NULL 
AND operation_date between cast('2021-01-01' as DATE) and cast('2021-06-01' as DATE) 
GROUP BY aa.area_id,aa.area_name,aa.order_service_server,aa.owner_id

Answer 1

先用explain sql语句执行一下，查看索引使用情况。