Q: Hash Join

From: Leonid Lamburt <ll01_at_gte.com>
Date: 1997/12/22
Message-ID: <01bd0ef4$d6c00740$0d87c584@buggs>#1/1

Oracle7 (7.3) Server Tuning manual says that Oracle can perform a hash join only for an equijoin (5-51 top). Then why when I am running the following commands
  SET autotrace on
  SELECT /*+ FULL(t2) */ a.id, a.name, b.aux   FROM t1 a, t2 b
  WHERE a.id = b.id (+);
the execution plan indicates that HASH JOIN is used for the prev.statement?

Is it something I missed? Received on Mon Dec 22 1997 - 00:00:00 CST