Table alias has an effect with execution time?
- by RedFux227
So I have this query :
SELECT A.e_cd "INFLATE" , A.ccgpt "1" , ( SELECT J.comp
FROM JBB J
WHERE J.e_cd=A.e_cd
AND emplo_RCD=:1
AND J.Dte = ( SELECT MAX(J1.Dte)
FROM JBB J1
WHERE J.e_cd=J1.e_cd
AND TO_CHAR(J1.Dte,'MM') <=A.mth_to
AND TO_CHAR(J1.Dte,'YYYY') <=A.year )
AND J.seq = ( SELECT MAX(J2.seq)
FROM PS_JOB J2
…