与表连接顺序的相关hint:执行顺序emp-jobs-deptSQL> select /*+ ordered */e.ename,j.job,e.sal,d.deptno from emp e,jobs j,dept d where e.empno=j.empno and e.deptno=d.deptno and d.loc='CHICAGO' order by e.ename;6 rows selected.Execution Plan------------------- ......
本文摘自 :https://7642644.blog.51c


