zOs/SQL/EXPLA5FI

-- select * from tstRts.TrtsReoTSException;
set current sqlid = 'A540769';
delete from  plan_table;
explain plan set queryno = 1 for
select count(*), min(verfall), max(verfall)
    from  GDB0351.vFI027A1 where tkKey = 5003240
;
explain plan set queryno = 11 for
select count(*), min(verfall), max(verfall)
    from  GDB0351.vFI027A1 where tkKey = ?
;
select * from plan_view2
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;