zOs/TX/PER13EXQ

set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_PREDICAT_TABLE;
delete from A540769.DSN_FILTER_TABLE;
explain plan set queryno = 1   for
  select * from A540769.tper13 where i1=? and ? = i2 ;
explain plan set queryno = 2   for
  select * from A540769.tper13 where i1=? and j2 = ?;
explain plan set queryno = 3   for
  select * from A540769.tper13 where i1=? and k2 = ?;
explain plan set queryno = 4   for
  select * from A540769.tper13 where i1=? and l2 = ?;
explain plan set queryno = 5   for
  select * from A540769.tper13 where i1=? and m2 = ?;
explain plan set queryno = 6   for
  select * from A540769.tper13 where i1=? and n2 = ?;
explain plan set queryno = 7   for
  select * from A540769.tper13 where i1=? and o2 = ?;
explain plan set queryno = 11  for
  select * from A540769.tper13 where i1=? and i2 in (?, ?, ?);
explain plan set queryno = 12   for
  select * from A540769.tper13 where i1=? and j2 in (?, ?, ?);
explain plan set queryno = 13   for
  select * from A540769.tper13 where i1=? and k2 in (?, ?, ?);
explain plan set queryno = 14   for
  select * from A540769.tper13 where i1=? and l2 in (?, ?, ?);
explain plan set queryno = 15   for
  select * from A540769.tper13 where i1=? and m2 in (?, ?, ?);
explain plan set queryno = 16   for
  select * from A540769.tper13 where i1=? and n2 in (?, ?, ?);
explain plan set queryno = 17   for
  select * from A540769.tper13 where i1=? and o2 in (?, ?, ?);
explain plan set queryno = 21  for
  select * from A540769.tper13 where i1=? and i2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 22   for
  select * from A540769.tper13 where i1=? and j2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 23   for
  select * from A540769.tper13 where i1=? and k2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 24   for
  select * from A540769.tper13 where i1=? and l2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 25   for
  select * from A540769.tper13 where i1=? and m2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 26   for
  select * from A540769.tper13 where i1=? and n2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 27   for
  select * from A540769.tper13 where i1=? and o2 in (?, ?, ?)
                                          and o2 in (?, ?, ?);
explain plan set queryno = 36   for
  select a.* from A540769.tper13 a, A540769.tper13 b
      where a.i1=? and a.n2 in (?, ?, ?)
        and b.i1=? and b.n2 in (?, ?, ?);
explain plan set queryno = 37   for
  select b.* from A540769.tper13 a, A540769.tper13 b
      where a.i1=? and a.n2 in (?, ?, ?)
        and b.i1=? and b.n2 in (?, ?, ?);
explain plan set queryno = 46   for
  select a.* from A540769.tper13 a, A540769.tper13 b
      where a.i1=? and a.n2 in (?, ?, ?) and a.o2 in (?, ?, ?)
        and b.i1=? and b.n2 in (?, ?, ?) and b.o2 in (?, ?, ?);
explain plan set queryno = 46   for
  select b.* from A540769.tper13 a, A540769.tper13 b
      where a.i1=? and a.n2 in (?, ?, ?) and a.o2 in (?, ?, ?)
        and b.i1=? and b.n2 in (?, ?, ?) and b.o2 in (?, ?, ?);
select * from  plan_view1
    order by applname, progname, queryNo, qblockno, planno, mixOpSeq
;
select * from  plan_viewPred
    order by collid, progName, applName, explain_time,
             queryNo, qBlockNo, planno,
             stage, predno
;
commit