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
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