zOs/SQL/EXPLAIN0

--- versionen, compiles und explains eines packages -------------------
select *
    from cmnbatch.plan_view0
    where   collid       = 'MF'
        and prog         = 'MF7010'
    order by pcEx  desc, explain_time desc
    with ur
;x;
--- ausgewählte Explains analysieren
select *
    from cmnbatch.plan_view1
 -- from cmnbatch.plan_view2Det
    where     collid     = 'MF'
        and progName     = 'MF7010'
        and explain_time = '2011-08-30-14.14.59.234601'
    order by collid, progName, version, explain_time,
             queryno, qBlockNo, planno, mixopSeq
    with ur
;
select *
    from cmnbatch.plan_viewPred
    where     collid     = 'MF'
        and progName     = 'MF7010'
        and explain_time = '2011-08-30-14.14.59.234601'
    order by collid, progName, explain_time,
             queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
    with ur
;