zOs/TX/PER05SFW

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

explain plan set queryno = 2 for
  select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionWhere
     where da between date(char(date('30.05.2011')))
                  and date('02.06' || '.2011')
;
select * from plan_table
    order by applname, progname, queryNo, qblockno, planno
;
select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionWhere
     where da between '30.05.2011' and '02.06.2011'
;
rollback;