READING EXPLAIN PLAN

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Mon, 17 Sep 2001 12:07:01 -0700
Message-ID: <F001.00390CA7.20010917120528@fatcity.com>

HOw doyou read the explain plan outout ? I format it with a script and still do not know how to read it . Which line I must read first?The output of my explain plan is below and how do you read this output pleASE?
 

<FONT face=Arial

size=2>OPERATION                              
 
OPTIONS                        
OBJECT_NAME                      
POSITION------------------------------           
------------------------------               ------------------------------                      

 ----------SELECT

STATEMENT                                                                                  


                         

3141 

FILTER                                                                                                                                 

 1    HASH

JOIN                         

  

OUTER                                                                                   1      

HASH

JOIN                                                                                                                        

1        HASH

JOIN                                                                                                                      1          

TABLE
ACCESS             

FULL                                

 

K_GD_AB_BINA                            
1          HASH 
JOIN                                                                  


                

            

                     

2            TABLE 
ACCESS            
FULL                           


        

BOLUM                                       

1            HASH
JOIN             
    

OUTER                                                          


             

            

2             
MERGE JOIN      
      

CARTESIAN                                                                            
1                
TABLE ACCESS       BY INDEX 
ROWID                 
KODLAR                


                     

1                  

INDEX             
      RANGE

SCAN                       

IND_KODLAR_KOD_TABLO        

1                
SORT              


         

JOIN                                                                   


                

   

2                  
TABLE ACCESS     BY INDEX 
ROWID                 
KODLAR                                  

   

1                    

INDEX             
    RANGE

SCAN                     

IND_KODLAR_KOD_TABLO           

1              
TABLE ACCESS         
FULL                             

     

KADRO_TERFI                             

2        TABLE
ACCESS          
   

FULL                           


        

SICIL                                     

       2      TABLE

ACCESS            
   

FULL                           

       

KADRO_TERFI              
 

Here is my sql .

SELECT T_SICIL.KURUM_SICIL_NO, T_SICIL.AD,T_SICIL.SOYAD, T_SICIL.AYR_TRH, T_SICIL.SAKAT_GRB, T_BOL.BIRIMKOD,T_BOL.BOLUMAD AS BIRIMI,T_BOL.BOLUMAD2 AS GOREV_YERI, T_BOL.KAT, T_BOL.ODA_NO, T_KADRO.DOGUM_YILI, T_KOD.KODACK AS UNVANI,T_KADRO.UNVAN2, T_KODG.KODACK, T_KADROG.GOREV,T_SICIL.DOGUM_TRH AS DOGUM_TARIHI,T_BOL.BINA_KOD ,T_BINA.BINA_ADI AS BINA FROM
 KADRO_TERFI T_KADRO, SICIL T_SICIL, BOLUM T_BOL, S_UYAPPERS_KODLAR
T_KOD, S_K_GD_AB_BINA T_BINA, S_UYAPPERS_KODLAR T_KODG, KADRO_TERFI T_KADROG
WHERE
 (T_KADRO.SICIL_NO = T_SICIL.SICIL_NO) AND (T_KADRO.BRM =
T_BOL.BIRIMKOD )AND (T_KADRO.UNVAN2 (+) = T_KOD.KOD AND T_KOD.TABLO = 'UNVAN'<FONT
color=#000000 size=1>) AND (T_BOL.BINA_KOD = T_BINA.BINA_KODU)AND ((T_KADROG.SICIL_NO = T_SICIL.SICIL_NO) AND (T_KADROG.GOREV (+) = T_KODG.KOD AND T_KODG.TABLO = 'GOREV'<FONT color=#000000
size=1>)) Received on Mon Sep 17 2001 - 14:07:01 CDT