SQL Tuning – Ideas to optimize LEFT join
I need ideas to optimize this query ……
SELECT MT.ID,MT.TELEFONO,NVL(MT.TIPOTARJETA,'A'),
MT.FECHAESTADO,P.ESTATUS,MT.ESTADO,P.LIBRERIA
FROM PAGOSVT.MT_PAGO MT
LEFT JOIN
PAGOSVT.POL_02_T_PAGO P
ON MT.ID = P.TRANSACCION
AND P.ADQUIRIENTE = 'MKT'
WHERE TO_CHAR(MT.FECHAESTADO,'YYYY-MM-DD') = '2013-03-05'
AND MT.ESTADO IN ('T55', 'T11')
ORDER BY MT.ID,MT.FECHAESTADO
TOTAL ROWS
PAGOSVT.MT_PAGO, =4758603
PAGOSVT.POL_02_T_PAGO = 1263922
QUERY = 5174
This is the Execution Plan:
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 19515 | 1600K| | 59533 (2)| 00:11:55 |
| 1 | SORT ORDER BY | | 19515 | 1600K| 1848K| 59533 (2)| 00:11:55 |
|* 2 | HASH JOIN OUTER | | 19515 | 1600K| | 59147 (2)| 00:11:50 |