昨天在看落落的博客,http://blog.csdn.net/robinson1988/article/details/7047961
对于子查询反嵌套以及树形查询的关系实在是有点麻烦,稍作个实验。
SQL> select * from emp a where exists (
select ename from emp b where a.empno=b.empno start with ename = 'KING' connect by prior mgr = empno);
Execution Plan
----------------------------------------------------------
Plan hash value: 1890947587
---------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 45 | 24 (0)| 00:00:01 |
|* 1 | FILTER | | | | | |
| 2 | TABLE ACCESS FULL | EMP | 14 | 630 | 3 (0)| 00:00:01 |
|* 3 | FILTER | | | | | |
|* 4 | CONNECT BY NO FILTERING WITH SW (UNIQUE)| | | | | |
| 5 | TABLE ACCESS FULL | EMP | 14 | 196 | 3 (0)| 00:00:01 |
------------------------------------------------------------------------