zOs/TX/PER05SE1

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

explain plan set queryno = 1 for
  select count(*),  min(ix), max(ix)
     from A540769.tPer05x1
     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.tPer05x1
     where da between '30.05.2011' and '02.06.2011'
;
rollback;