CBO与RBO下的IN/EXISTS

<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>

   晚上抽空看了看asktom的RSS，发现两篇应该说很入门的关于 IN/ EXISTS的文章：http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:953229842074，http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:442029737684   文章很长，也没有仔细看完，不过有些东西还是很有意思的，动手实验了一下。大家随便看看咯，Tom当初回答问题的环境我已经没办法测试了，在10.1.0.4下做了些测试， CBO和 RBO（使用h INts）下还是很大区别的。SQL>select*fromscott.emp;    EMPNOENAME     JOB             MGRHIREDATE             SAL      COMM    DEPTNO-----------------------------------------------------------------------------------     7369SMITH     CLERK          790217-12月-80           800                   20     7499ALLEN     SALESMAN       769820-2月-81          1600       300        30     7521WARD      SALESMAN       769822-2月-81          1250       500        30     7566JONES     MANAGER        783902-4月-81          2975                   20     7654MART IN    SALESMAN       769828-9月-81          1250      1400        30     7698BLAKE     MANAGER        783901-5月-81          2850                   30     7782CLARK     MANAGER        783909-6月-81          2450   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>