zOs/SQL/KE5480C

set current sqlId = 'A540769';
delete   from A540769.plan_table
;
explain plan        set queryno = 300 for
                                      SELECT DISTINCT V833.PARTNER_KEY,
V831.PARTNER_ID, V858.IDENT_ID, V843.TAB_TEXT3, V858.VALID_TO_DATE aa,
V859.VALID_TO_DATE bb, V859.APPLICATION_TYPE
FROM oa1p.VKS831A1V V831,
oa1p.VKS833A1V V833, oa1p.VKS835A1V V835
 , oa1p.VKS843A1V V843, oa1p.VKS843A1V V843B,
   oa1p.VKS858A1V V858, oa1p.VKS859A1V V859
WHERE V833.PARTNER_KEY >= ' ' AND
V833.PARTNER_TYPE = 3
  AND V831.PARTNER_KEY = V833.PARTNER_KEY AND
V835.PARTNER_KEY = V833.PARTNER_KEY AND V835.PARTNER_TYPE = 3 AND
V835.CONTRACT_KEY = V833.CONTRACT_KEY
   AND V858.PARTNER_KEY =
V833.PARTNER_KEY AND V859.IDENT_ID = V858.IDENT_ID AND V843.TAB_ART =
'PRODUCT_ID' AND V843.TAB_CODE = V835.PRODUCT_ID AND V843.TAB_TYPE2 =
V858.IDENT_TYPE AND V843B.TAB_ART = 'APPLICATION_IDENT' AND
V843B.TAB_TEXT3 = V843.TAB_TEXT3 AND V859.APPLICATION_TYPE =
V843B.TAB_TYPE1
AND (  V833.LAST_UPDATE_TIME > current timestamp - 7 days
    or V835.LAST_UPDATE_TIME > current timestamp - 7 days
    OR V858.VALID_TO_DATE BETWEEN  current date  - 7 days
                  and current date + 7 days
    or V859.VALID_TO_DATE BETWEEN  current date - 7 days
                  and current date + 7 days
    OR V859.VALID_FROM_DATE >= current date - 7 days
    )
;
select index, v.* from plan_view5a v
    order by             applname, progname, queryNo, timestamp ,
        qblockno, planno
;
rollback
;
                                      SELECT DISTINCT V833.PARTNER_KEY,
V831.PARTNER_ID, V858.IDENT_ID, V843.TAB_TEXT3, V858.VALID_TO_DATE aa,
V859.VALID_TO_DATE bb, V859.APPLICATION_TYPE
FROM oa1p.VKS831A1V V831,
oa1p.VKS833A1V V833, oa1p.VKS835A1V V835
 , oa1p.VKS843A1V V843, oa1p.VKS843A1V V843B,
   oa1p.VKS858A1V V858, oa1p.VKS859A1V V859
WHERE V833.PARTNER_KEY >= ' ' AND
V833.PARTNER_TYPE = 3
  AND V831.PARTNER_KEY = V833.PARTNER_KEY AND
V835.PARTNER_KEY = V833.PARTNER_KEY AND V835.PARTNER_TYPE = 3 AND
V835.CONTRACT_KEY = V833.CONTRACT_KEY
   AND V858.PARTNER_KEY =
V833.PARTNER_KEY AND V859.IDENT_ID = V858.IDENT_ID AND V843.TAB_ART =
'PRODUCT_ID' AND V843.TAB_CODE = V835.PRODUCT_ID AND V843.TAB_TYPE2 =
V858.IDENT_TYPE AND V843B.TAB_ART = 'APPLICATION_IDENT' AND
V843B.TAB_TEXT3 = V843.TAB_TEXT3 AND V859.APPLICATION_TYPE =
V843B.TAB_TYPE1
AND (  V833.LAST_UPDATE_TIME > current timestamp - 7 days
    or V835.LAST_UPDATE_TIME > current timestamp - 7 days
    OR V858.VALID_TO_DATE BETWEEN  current date  - 7 days
                  and current date + 7 days
    or V859.VALID_TO_DATE BETWEEN  current date - 7 days
                  and current date + 7 days
    OR V859.VALID_FROM_DATE >= current date - 7 days
    )
;