From sqlgreg@pacbell.net Mon, 17 Sep 2001 13:03:39 -0700
From: Greg Moore <sqlgreg@pacbell.net>
Date: Mon, 17 Sep 2001 13:03:39 -0700
Subject: Re: READING EXPLAIN PLAN
Message-ID: <F001.00390E4C.20010917131041@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



>> How do you read the explain plan 
output?
 
See, Use EXPLAIN PLAN and TKPROF To Tune Your 
Applications
<A 
href="http://www.dbspecialists.com/4dbas/presos/use_explain.html">http://www.dbspecialists.com/4dbas/presos/use_explain.html
 
 
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  <A href="mailto:bunyamink@HAVELSAN.COM.TR" 
  title=bunyamink@HAVELSAN.COM.TR>Bunyamin K. Karadeniz 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Monday, September 17, 2001 1:05 
  PM
  Subject: READING EXPLAIN PLAN
  
  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>))