Re: Best way to optimize SQL

[Peter Brawley]

That query simplifies to ...

select emplid, pay_end_dt`, sum(hours) as sumofhours
from x_hoursworked_base2_ds
where off_cycle = 'n' and pay_end_dt >= date_sub(curdate(), interval 1100 day)
group by emplid, pay_end_dt;

For optimisation, let's see the result of running Explain on the query, the result of Show Create Table x_hoursworked_base2_ds, and either the result of ...

show variables like 'innodb%';

or if the table isn't InnoDB then why not.



Edited 1 time(s). Last edit at 04/15/2018 01:05PM by Peter Brawley.