zOs/SQL/EXPLAIWP

-- versionen, Compiles und Binds pro Programm
select * from A540769.plan_view0
    where name like 'YWPR2PX'
    order by co, pg, pcTimestamp desc, bind_time desc
    with ur
;
select * from  cmnbatch.plan_table
    where progname = 'YWPR2PX'
        and bind_time='2011-05-12-12.20.06.467267'
    -- DBH0000211602508  2011-02-11-11.36.35.916411
    order by applname, progname, queryNo, qblockno, planno, mixOpSeq
;
set current sqlid = 'A540769';
delete from A540769.plan_table;
explain plan set queryno = 3   for
select *             FROM oa1t.TWP011A101 WHERE WP011_DEPOT_NR = ?
AND WP011_VALOR_NR LIKE ? AND WP011_POS_FOLGE = 0 ORDER BY
WP011_VALOR_NR, WP011_POS_SEQUENZ WITH UR
;
select * from  plan_view1
    order by applname, progname, queryNo, qblockno, planno, mixOpSeq
;
rollback
;;;;;;;;