hash join 只支持等值连接

alter session set statistics_level=all; 

select /*+ use_hash(emp,dept) */ ename,job,sal ,dname,loc from emp,dept where emp.deptno=dept.deptno;



SQL> select /*+ use_hash(emp,dept) */ ename,job,sal ,dname,loc from emp,dept where emp.deptno=dept.deptno;

ENAME			       JOB				  SAL DNAME					 LOC
------------------------------ --------------------------- ---------- ------------------------------------------ ---------------------------------------
SMITH			       CLERK				  800 RESEARCH					 DALLAS
ALLEN			       SALESMAN 			 1600 SALES					 CHICAGO
WARD			       SALESMAN 			 1250 SALES					 CHICAGO
JONES			       MANAGER				 2975 RESEARCH					 DALLAS
MARTIN			       SALESMAN 			 1250 SALES					 CHICAGO
BLAKE			       MANAGER				 2850 SALES					 CHICAGO
CLARK			       MANAGER				 2450 ACCOUNTING				 NEW YORK
SCOTT			       ANALYST				 3000 RESEARCH					 DALLAS
KING			       PRESIDENT			 5000 ACCOUNTING				 NEW YORK
TURNER			       SALESMAN