[转载]30个Oracle语句优化律例详解(5)

20.用表跟尾交流EXISTS 屡屡来说,给与表跟尾的编制比EXISTS更有效率 SELECT ENAME FROM EMP E WHERE EXISTS (SELECT ‘X’ FROM DEPT WHERE DEPT_NO = E.DEPT_NO AND DEPT_CAT = ‘A&a


posted @ 2011-03-06 23:39  蓝色的天空III  阅读(80)  评论(0编辑  收藏  举报