zOs/SQL/EXPLAIMI

set current sqlid = 'A540769';
delete from plan_table;
explain plan set queryno = 1 for
    select count(*)              from OA1T.VPC060A1A
    where SUBSTR(SECURITY#,1,10)  = ?
    and   SEC_IDENT_SYS = 1 with ur;
explain plan set queryno = 2 for
    select count(*)              from OA1T.VPC060A1A
    where SECURITY# like   ?
    and   SEC_IDENT_SYS = 1 with ur;
explain plan set queryno = 3 for
    select count(*)              from OA1T.VPC060A1A
    where SECURITY# like   ? || '%'
    and   SEC_IDENT_SYS = 1 with ur;
select * from plan_view2
    order by applname, progname, queryNo, qblockno, planno
;
rollback;