zOs/SQL/OPTHISIP

set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table  ;
delete from A540769.dsn_predicat_table;
delete from A540769.dsn_userquery_table;
INSERT INTO DSN_USERQUERY_TABLE
    ( QUERYNO, SCHEMA, HINT_SCOPE
    , QUERY_TEXT
    )
    SELECT 70, p.qualifier, 0, -- 0=system, 1=package
        s.STATEMENT
    from sysibm.sysPackStmt s
      join sysibm.sysPackage p
        on s.location = p.location and s.collid = p.collid
          and s.name = p.name
          and s.version = p.version and s.contoken = p.contoken
    where s.location  ='' and s.collid = 'BP' and s.name = 'YBPSUCH'
          and s.version = 'BPST000070594A877D'
          and s.queryno = 713
;
explain plan set queryno = 70  for
SELECT A.BP20401, A.BP20404, A.BP20410, A.BP20411, B.BP20004,
B.BP20017, B.BP20013, B.BP20022, C.BP20501, C.BP20504, C.BP20509,
C.BP20510, C.BP20512
FROM oa1p.TBP204A1 A, oa1p.TBP200A1 B, oa1p.TBP205A1
C WHERE A.BP20401 = ? AND A.BP20402 <= ? AND A.BP20403
>= ? AND A.BP20405 = ? AND A.BP20409 = 'A' AND
B.BP20001 = A.BP20411 AND B.BP20002 <= ? AND B.BP20005 =
? AND B.BP20003 >= ? AND C.BP20501 = A.BP20411 AND
C.BP20502 <= ? AND C.BP20503 >= ?
AND C.BP20505 = '9999-12-31-23.59.59.999999'
  AND ( ( C.BP20508 = 1 AND C.BP20513 <> 'LAE ' ) OR (
C.BP20508 = 3 AND C.BP20513 = 'LAE ' ) )
;
commit
;
select * from  plan_view1
    order by -- collid, progName, version, bind_time,
             queryNo, qblockno, planno, mixOpSeq