执行计划结构如下：
nested loop
outer table --驱动表
inner table

hash join
build table (inner table) --驱动表
probe table (outer table)

hash join的详细机制
http://www.360doc.com/content/11/0625/17/2660674_129507672.shtml

Oracle Nested Loop Join及Hash Join - 3