PAY_OTH_EARNS and TL_XREF_TBL performance issue
Hi All,
I am using the below sql to get the location details from TL_PAYABLE_TIME. But the time DDP003 process taking is longer time than expected. Actual run time is 15 minutes. Currently taking 180 minutes after changes.
SELECT OE.ERNCD, OE.COMP_RATECD, OE.COMPRATE_USED, OE.OTH_HRS, OE.OTH_EARNS, OE.OTH_PAY, OE.HRS_DIST_SW,
OE.RATE_USED, SUM(L.TL_QUANTITY), L.location
FROM PS_PAY_OTH_EARNS OE , PS_TL_XREF_TBL B, PS_TL_PAYABLE_TIME L
where OE.COMPANY = 'XXX'
AND OE.PAYGROUP = 'XXX'
and OE.PAY_END_DT = '21-NOV-20'