Question about hash join in nested loop

  • From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 16 Sep 2006 20:03:31 +0100

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

Other related posts: