zOs/SQL/EXPLAICT

--- versionen, compiles und explains eines packages ---
select *
    from cmnbatch.plan_view0
    where   collid       = 'CZ'
        and prog         = 'YCTS100'
    order by pcBi  desc, bind_Time desc
    with ur
;
--- ausgewählte Explains analysieren
select *
    from cmnbatch.plan_view1
 -- from cmnbatch.plan_view2
 -- from cmnbatch.plan_view2Det
    where     collid     = 'CZ'
        and progName     = 'YCTS100'
        and bind_time in ( '2012-05-10-12.20.00.991461'
                          ,'2010-11-11-15.02.50.081875'
                          )
    order by collid, progName, version,
             bind_time,
             queryno,
             qBlockNo, planno, mixopSeq
    with ur