oracle using index even though there is no filter criteeria specified
- by Kaushik
In this query:
SELECT WTTEMPLATE.TEMPLATEuID,
MAX (WTTRX.VALUEDATE) AS template_last_use_date
FROM wttemplate, wttrx
WHERE WTTEMPLATE.TEMPLATEID = WTTRX.TEMPLATEID(+)
AND WTTEMPLATE.CUSTID = WTTRX.CUSTID
GROUP BY WTTEMPLATE.TEMPLATEuID
The explain plan shows:index…