WHERE TO_CHAR(EMP_EXP_DATE, ‘YYYY’) = ‘1998’ AND EMP_DEPT = DPT_ID
The alternative syntax is:
SELECT /*+ NO_CPU_COSTING */ MAX(EMP_SALARY)
AND EMP_DEPT = DPT_ID || **’’
**Why would the alternative statement be considered a candidate for being deployed as an outline? I think I’m stuck on this notion that the alternative statement has to be identical to the original (or currently deployed) statement.
WHERE TO_CHAR(EMP_EXP_DATE, ‘YYYY’) = ‘1998’
I’ve run the optimizer on a particulare statement and have received an alternative statment that is a candidate for being deployed as an outline. I’m confused as to how the new statement could be considered as a candidate given that the SQL syntax is not identical to the original.
The original syntax is as follows:
DEPARTMENT FROM DEPARTMENT,