zOs/SQL/EXPLAKAU

set current sqlid = 'A540769';
delete from plan_table;
explain plan set queryno = 111 for
SELECT FI10.TKKEY                   AS TKKEY
      ,KK2.VR4204S                  AS UNDERLAYER
      ,KK2.VR4204L                  AS LAUFNR
      ,KK2.VR4204G                  AS GENERATION
      ,KK2.KA4204T                  AS VERFALLP42
      ,KK1.KA4205                   AS VERFALLP42DD
      ,FI10.VERFALL                 AS VERFALLFI04
      ,KK2.KA4204W                  AS BASISPREIS
      ,KK2.KA4204A                  AS KONTRAKT
      ,KK2.KK4222P                  AS BOERSE
      ,KK2.KK4222W                  AS WHRG
      ,FI21.KURSDATUM               AS KURSDATUM
      ,FI21.KURS_LIEFERUNG          AS PRICEFI04
   FROM GDB0503.KK2   KK2
       ,GDB0503.KK1   KK1
       ,GDB0503.KB    KB
       ,GDB0503.FI10  FI10
       ,GDB0503.FI21  FI21
  WHERE KB.VR4204S       = KK2.VR4204S
    AND KB.VR4204L       = KK2.VR4204L
    AND KB.VR4204G       = KK2.VR4204G
    AND KB.KB4212P       = KK2.KK4222P
    AND KB.KB4212W       = KK2.KK4222W
    AND KK1.VR4204S      = KK2.VR4204S
    AND KK1.VR4204L      = KK2.VR4204L
    AND KK1.VR4204G      = KK2.VR4204G
    AND KK1.KA4204T      = KK2.KA4204T
    AND KK1.KA4204W      = KK2.KA4204W
    AND KK1.KA4204A      = KK2.KA4204A
    AND FI10.UNDERLAYER  = KK2.VR4204S
    AND FI10.LAUFNR      = KK2.VR4204L
    AND FI10.GENERATION  = KK2.VR4204G
    AND (
         ( FI10.VERFALL  = '99991231'   )
       OR
         ( FI10.VERFALL  = KK2.KA4204T  )
        )
    AND FI10.BASISPREIS  = KK2.KA4204W
    AND FI10.KONTRAKT    = KK2.KA4204A
    AND FI10.BOERSE      = KK2.KK4222P
    AND FI10.WHRG        = KK2.KK4222W
    AND FI21.TKKEY       = FI10.TKKEY
    AND FI21.BOERSE      = FI10.BOERSE
    AND FI21.WHRG        = FI10.WHRG
    AND ( FI21.KURSDATUM = KK2.KK4224D_01
       OR FI21.KURSDATUM = KK2.KK4224D_02
       OR FI21.KURSDATUM = KK2.KK4224D_03
       OR FI21.KURSDATUM = KK2.KK4224D_04
       OR FI21.KURSDATUM = KK2.KK4224D_05
        )
       with ur
;
select * from plan_view5a
    where queryno in ( 111, 222)
    order by applname, progname, queryNo, qblockno, planno
;
rollback;