Best way to optimize SQL

[Matthew Fierro]

I am trying to make the following sql run faster. What is the best way to optimize? The table x_hoursworked_base2_ds has 22M rows.


SELECT ERN.EMPLID
,ERN.PAY_END_DT`
,SUM(ERN.HOURS) as SumOfHours
FROM
(SELECT
A.EMPLID
,A.PAY_END_DT
,A.HOURS
FROM x_hoursworked_base2_ds A
where A.OFF_CYCLE = 'N'
AND A.PAY_END_DT >= DATE_SUB(NOW(), INTERVAL 1100 DAY)) ERN
group by
ERN.EMPLID
,ERN.PAY_END_DT