Re: READING EXPLAIN PLAN

[Greg Moore]

>> How do you read the explain plan output?   See, Use EXPLAIN PLAN and TKPROF To Tune Your Applications http://www.dbspecialists.com/4dbas/presos/use_explain.html     ----- Original Message ----- From: Bunyamin K. Karadeniz To: 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?   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') 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'))