Question about hash join in nested loop

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Sat, 16 Sep 2006 20:03:31 +0100
Message-ID: <5e317f310609161203m25f2bf6ajdb98dd1d78fd561c@mail.gmail.com>

Oracle version: 8.1.7.4

Hi,
I have an execution plan like this:
NESTED LOOPS
  HASH JOIN

      table
      table

    table access by index

Does Oracle only do the hash join once as the first data source of the nested loop or does it get done many times?

--

Regards

Pete

--

http://www.freelists.org/webpage/oracle-l Received on Sat Sep 16 2006 - 14:03:31 CDT