zOs/SQL/PXT2300

set current sqlid = 'A540769';
delete from plan_table;
explain plan set queryno = 111 for
SELECT BP20001,BP20004,BP20007,BP20008,BP20010,
BP20011,BP20012,BP20013,BP20014,BP20015,BP20016,
BP20017,BP20019,BP20022,BP20024,BP20025,BP20026,
BP20027,BP20028,BP20029,BP20401,BP20404,BP20409,
BP20410,BP20502,BP20503,BP20504,BP20508,BP20509,
BP20510,BP20511,BP20512
FROM oa1t.TBP200A1,oa1t.TBP204A1,oa1t.TBP205A1
WHERE BP20001=BP20411 AND BP20001=BP20501
AND '2008-04-01-00.00.00.000000' BETWEEN BP20002 AND BP20003
AND BP20005=?
AND BP20403=?
AND BP20405=?
AND BP20503>=?
AND BP20505=?
AND BP20401 BETWEEN ?    AND ?
AND BP20409=?    AND BP20008=?
ORDER BY BP20008,BP20401 DESC
FOR FETCH ONLY WITH UR
;
select * from plan_view5a
    where queryno in ( 111, 222)
    order by applname, progname, queryNo, qblockno, planno
;
rollback;