zOs/SQL/EXPLAIXX

--- 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;
delete from A540769.dsn_query_table;
delete from A540769.dsn_queryInfo_table;
explain plan set queryno = 3   for
    select oa1p.fosFmtE7(cardF)
        from sysibm.sysTables
        where creator = 'SYSIBM' and name like 'SYSTAB%'
        order by cardf Desc
;
select * from  plan_view1
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_view2det
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select *
    from plan_viewPred
    order by collid, progName, explain_time,
             queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
    with ur
;
select * from  plan_table
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno, planno, mixOpSeq
;
select * from  dsn_function_table
    order by -- collid, progName, version, explain_time,
             queryNo, qblockno
;
select * from  dsn_STAT_FEEDBACK
;
select * from A540769.dsn_query_table;
select * from A540769.dsn_queryInfo_table;
rollback
;;;;