I have this query and it take about 4.5 minutes to return 253 records. Can someone tell me how to make left join in sub query more efficient way to reduce the time to run this query
SELECT A.EMPLOYEE, B.CHECK_DATE, B.DED_CODE, B.DED_AMT
FROM
(SELECT EMPLOYEE FROM BENEFIT WHERE PLAN_CODE = 'FSAM' AND (STOP_DATE='1/1/1753' OR STOP_DATE > GETDATE())
AND YEAR(START_DATE) = 2020) A LEFT OUTER JOIN
(SELECT EMPLOYEE, DED_AMT, DED_CODE, CHECK_DATE FROM PAYDEDUCTN WHERE PAYDEDUCTN.DED_CODE = 'FSME' AND (CHECK_DATE = '4/10/2020')) B
ON A.EMPLOYEE=B.EMPLOYEE
ORDER BY A.EMPLOYEE