RE: 4 join methods?

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Fri, 01 Jun 2001 09:00:30 -0700
Message-ID: <F001.00317B67.20010601062557@fatcity.com>

Hi,
DBAs,
RTFM is so boring,
but... There is cut&paste from
<FONT

face="Times New Roman" size=3>"Oracle8i Designing and Tuning for Performance"
   The
Optimizer
<SPAN

class=369392313-01062001>     Optimizing joins
<SPAN

class=369392313-01062001>

      Join 
      Operations  
    
      To join each pair of row sources, 
      Oracle must perform one of these operations: 
      
        <A 
        href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/optimops.htm#36280"><FONT 
        face=Courier>Nested Loops (NL) Join<FONT 
        face=Courier> 
        
        <A 
        href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/optimops.htm#36312"><FONT 
        face=Courier>Sort-Merge Join<FONT 
        face=Courier> 
        
        <A 
        href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/optimops.htm#36362"><FONT 
        face=Courier>Hash Join<FONT 
        face=Courier> (not available with the RBO) 
        
        <A 
        href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/optimops.htm#36428"><FONT 
        face=Courier>Cluster Join<FONT 
        face=Courier>

<FONT face=Courier

size=2>Cheers,
Vadim
Gorbounov
Oracle DBA Received on Fri Jun 01 2001 - 11:00:30 CDT