zOs/SQL/EXPLAIFI

--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table ;
explain plan set queryno = 27  for
  select kurs_umrechnung,
         kursdatum,
         whrg,
         cs_ka_num,
         excode,
         ks_bpl_st,
         ks_ais_sp
    from oa1a.vfi027a1
   where tkkey        = 10930000
     and verfall      = ?
     and boerse       = ?
     and whrg         = ?
     and status       = 'A'
     and kursdatum   <= ?
     and kursdatum   >= ?
     and ks_bpl_st   >= ?
     and ks_bpl_st   <= ?
     and ks_ais_sp   >= ?
     and ks_ais_sp   <= ?
     and cs_ka_num   >= ?
     and cs_ka_num   <= ?
     and cs_ka_num   <> ?
   order by kursdatum desc
   fetch first 1 row only
    with ur
;
select * from  plan_view1
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by --collid, progName, applName, explain_time,
             queryNo, qBlockNo, planno,
             stage, predNo
    with ur
;
rollback
;;;;