Scope of a hint

The scope of a hint is at the statement block level. This would be either for the entire statement in a simple query or for the parent statement or subquery level in a complex query.

The following is a hint that applies only to a subquery:

SELECT ename, empno, job FROM emp
WHERE deptno IN
    (SELECT /*+ RULE */ deptno FROM dept WHERE dname = 'SALES'),
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.65.61