Tuesday, August 5, 2008

Specifying a Set of Hints

Example of adding a hints to sql statement


SELECT
/*+ LEADING(e2 e1) USE_NL(e1)
INDEX(e1 emp_emp_id_pk) USE_MERGE(j)
FULL(j) */
e1.first_name, e1.last_name, j.job_id,
sum(e2.salary) total_sal
FROM employees e1, employees e2, job_history j
WHERE e1.employee_id = e2.manager_id
AND e1.employee_id = j.employee_id
AND e1.hire_date = j.start_date
GROUP BY e1.first_name, e1.last_name, j.job_id
ORDER BY total_sal;






****************************************
rdbms ver: 11g
****************************************
keywords: hints
****************************************

No comments: