Re: READING EXPLAIN PLAN

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Mon, 17 Sep 2001 13:03:39 -0700
Message-ID: <F001.00390E4C.20010917131041@fatcity.com>

>> 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_at_HAVELSAN.COM.TR" title=bunyamink_at_HAVELSAN.COM.TR>Bunyamin K. Karadeniz To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_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

  2                  
  TABLE ACCESS     BY INDEX 
  ROWID                 
  KODLAR

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 - 15:03:39 CDT