RBO和CBO下的NOTIN/NOTEXISTS与外关联

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

SQL>analyzetablescott.empcomputestatisticsfortableforallcolumns;

表已分析。

已用时间: 00:00:06.06

SQL>select*fromscott.empe 2 wheree.empno NOTIN(selectmgrfromscott.emp);

未选定行

已用时间: 00:00:00.00

ExecutionPlan----------------------------------------------------------                                           0     SELECTSTATEMENTOptimizer=CHOOSE(Cost=4Card=1Bytes=32)                                 1   0  FILTER                                                                                   2   1    TABLEACCESS(FULL)OF'EMP'(Cost=2Card=1Bytes=32)                                  3   1    TABLEACCESS(FULL)OF'EMP'(Cost=2Card=1Bytes=3)                                 



SQL>SQL>select*fromscott.empe 2 where NOTEXISTS(selectnullfromscott.empswheres.mgr=e.empno);

    EMPNOENAME     JOB             MGRHIREDATE         SAL      COMM    DEPTNO             -------------------------------------------------------------------------------                  7844TURNER    SALESMAN       769808-9月-81      1500         0        30                  7521WARD      SALESMAN       769822-2月-81      1250       500        30                  7654MARTIN    SALESMAN       769828-9月-81      1250      1400        30                  7499ALLEN     SALESMAN       769820-2月-81      1600       300        30                  7934MILLER    CLERK          778223-1月-82      1300                   10                  7369SMITH     CLERK          790217-12月-80       800                   20                  7876ADAMS     CLERK          778823-5月-87      1100                   20                  7900JAMES     CLERK          769803-12月-81       950                   30              1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>