Hello!
Can one give more than one hint in an select-statement?
Greetings
Bjørn

"bdj" <B.D.Jensenremove (AT) gmx (DOT) net> wrote

Yes you can.
This is an example from the Oracle 10g docs :

Example 16-1 Specifying a Full Set of Hints

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;
HTHMatthias Hoys

Hi!
Can I also do it in Oracle 8i (yes, yes I know it's desupported - we are
preparing upgrade...)
/Bjørn

"Matthias Hoys" <idmwarpzone_NOSPAM_ (AT) yahoo (DOT) com> skrev i en meddelelse
news:42e00493$0$29031$ba620e4c (AT) news (DOT) skynet.be...