文章作者 100test 发表时间 2007:03:14 13:42:33
来源 100Test.Com百考试题网
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/NESTED LOOP
<Outer Loop>
<Inner Loop>
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/SQL> 0select e.empno,e.ename,e.job,d.dname
2 from emp e,dept d
3 where e.deptno=d.deptno
4 and e.empno=7900.
![]()
EMPNO ENAME JOB DNAME
---------- ---------- --------- --------------
7900 JAMES CLERK SALES
![]()
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 NESTED LOOPS
2 1 TABLE ACCESS (BY INDEX ROWID) OF