Re: Question about hash join in nested loop

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_at_gmail.com> To: <oracle-l_at_freelists.org> 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

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