zOs/TX/PER05SEJ

set current sqlid = 'A540769';
delete from plan_table;

explain plan set queryno = 4 for
  select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionJoin
     where da between '30.05.2011' and '02.06.2011'
;
select * from plan_view2
    order by applname, progname, queryNo, qblockno, planno
;
select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionJoin
     where da between '30.05.2011' and '02.06.2011'
 --    and ix between 0530000000  and 0602999999
;
rollback;