zOs/TX/PER18EXP

--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table  ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 3   for
select a.k3, b.d9
    from tper18 a, tper18 b
    where a.k3 = b.d9 and b.k9 = 'xyzxyz'
;
explain plan set queryno = 9   for
select a.k9, b.d3
    from tper18 a, tper18 b
    where a.k9 = b.d3
;
explain plan set queryno = 11  for
select a.k3, b.k9
    from tper18 a, tper18 b
    where a.k3 = b.k9 and b.d9 = 'xyzxyz'
;
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
;;;;