Re: Question about hash join in nested loop

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 16 Sep 2006 20:50:33 +0100


If that's the entire plan, it gets done once.

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html


----- Original Message ----- From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, September 16, 2006 8:03 PM
Subject: Question about hash join in nested loop



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



--------------------------------------------------------------------------------


No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.4/448 - Release Date: 14/09/2006

--
//www.freelists.org/webpage/oracle-l


Other related posts: