zOs/SQL/EXPLAISH

select count(*), ckat, d$guea
    from OA1T.TWM005A1
    group by ckat, d$guea
    order by 1 desc
    fetch first 100 rows only
    with ur
;
set current sqlid = 'A540769';
delete from  plan_table;
explain plan set queryno = 3 for
SELECT *
  FROM OA1T.TWM005A1
 WHERE D$GUEA     <=    CURRENT TIMESTAMP
   AND D$GUEB     >=    CURRENT TIMESTAMP
   AND CSTAT    BETWEEN 'A' AND 'A'
   AND CDEFAULT BETWEEN 'C' AND 'C'
   AND CKAT        =    'SPDE'
;
select * from plan_view2
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;