zOs/WK/OPTHISEO

                               -- overview über opthints und history
with p as
(
  select explain_time, count(*) cPlan
    from oa1p.tQZ081OptHintPlan p
    group by explain_time
)
, j as
( select value(q.explain_time, p.explain_time) explain
       , case when q.explain_time is null then 0 else 1 end cQuery
       , case when p.explain_time is null then 0 else cPlan end cPlan
       , q.desc
    from oa1p.tQZ080OptHintQuery q
      full outer join p
        on q.explain_time = p.explain_time
)
select min(explain) explain_min
       , microSecond(max(explain)) max
       , sum(cQuery) cQuery
       , sum(cPlan) cPlan
       , desc
       , max(explain) explain_max
    from j
    group by trunc_timestamp(explain, 'ss'), desc
    order by 1 desc, desc
;
;x;
commit
delete from oa1p.tQZ080OptHintQuery
    where explain_time >= '2014-09-04-15.43.43.000000'
;
delete from oa1p.tQZ081OptHintPlan
    where explain_time >= '2014-09-04-15.43.43.000000'
;