zOs/SQL/EXPLAIRE

set current sqlid = 'A540769';
delete from A540769.plan_table;
explain plan set queryno = 0   for
   update s100447.tReoRunPart p
      set reoTime = (select rngTime
                         from s100447.vReoRunRng2 r
                         where r.tst = p.tst and r.rng = p.rng
                    )
    where part = paVon and reoTime is null
        and tst > current timestamp - 10 hours
        and exists  (select rngTime
                         from s100447.vReoRunRng2 r
                         where r.tst = p.tst and r.rng = p.rng
                    )
;
select * from  plan_view1
    order by applname, progname, queryNo, qblockno, planno, mixOpSeq
;
rollback
;;;;;
set current sqlid = 's100447';
  CREATE INDEX s100447.iReoRunPart2
    ON s100447.tReoRunPart
     (tst asc, rng asc, sta, reotst)
    not CLUSTER
    USING STOGROUP GSMS
    BUFFERPOOL BP1
;
commit
;