zOs/TX/PER05SJW

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

explain plan set queryno = 7 for
  select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionInt
     where ix between int(530000000)    and 602999999
;
select * from plan_table
    order by applname, progname, queryNo, qblockno, planno
;
  select count(*),  min(ix), max(ix)
     from A540769.vPer05UnionInt
     where ix between int(530000000) and  602999999
;
rollback;