Re: Q: Hash Join

Looks like ORACLE ignored your hint

Try this:
In the hint use the alias instead of the table name change
 /*+ FULL(t2) */
to read
/*+ FULL(b) */

>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 Sat Jan 03 1998 - 00:00:00 CST