EXPLAIN PLAN SET QUERYNO=231 FOR 00010002
-- WITH V AS 00020003
SELECT * 00030003
FROM OA1A.TFI011A1 00040013
WHERE FI01101A = 30000000 00050011
AND FI01102A = 2 00060004
AND FI01103A >= '01.01.1999' 00070004
; 00080003
SELECT * 00090012
FROM A540769.PLAN_VIEW5 V 00100014
WHERE QUERYNO = 231 00110012
ORDER BY APPLNAME, PROGNAME, QUERYNO, QBLOCKNO, PLANNO 00120012
; 00130012
EXPLAIN PLAN SET QUERYNO=231 FOR 00140012
-- WITH V AS 00150011
SELECT * 00160011
FROM OA1A.TFI011A1 00170013
WHERE FI01101A = 30000000 + 2 - 2 00180011
AND FI01102A = 2 00190011
AND FI01103A >= '01.01.1999' 00200011
; 00210011
SELECT * 00220012
FROM A540769.PLAN_VIEW5 V 00230014
WHERE QUERYNO = 231 00240012
ORDER BY APPLNAME, PROGNAME, QUERYNO, QBLOCKNO, PLANNO 00250012
; 00260012
EXPLAIN PLAN SET QUERYNO=231 FOR 00270012
-- WITH V AS 00280011
SELECT * 00290011
FROM OA1A.TFI011A1 00300013
WHERE FI01101A = DECIMAL(30000000) 00310011
AND FI01102A = 2 00320011
AND FI01103A >= '01.01.1999' 00330011
; 00340011
SELECT * 00350008
FROM A540769.PLAN_VIEW5 V 00360014
WHERE QUERYNO = 231 00370012
ORDER BY APPLNAME, PROGNAME, QUERYNO, QBLOCKNO, PLANNO 00380008
; 00390008
00400008
COMMIT; 00410003
SELECT UNDERLAYER , 00420001
LAUFNR , 00430001
VERFALL , 00440001
CASE WHEN BASISPREIS >= 10000000 THEN 9999999.999999 00450001
WHEN BASISPREIS <= -10000000 THEN -9999999.999999 00460001
ELSE DECIMAL(BASISPREIS,13,6) 00470001
END , 00480001
CASE WHEN KONTRAKT >= 10000000 THEN 9999999.999999 00490001
WHEN KONTRAKT <= -10000000 THEN -9999999.999999 00500001
ELSE DECIMAL(KONTRAKT ,13,6) 00510001
END , 00520001
VERSION , 00530001
MUT_TIMESTAMP, 00540001
TKKEY, YEAR(VERFALL), MONTH(VERFALL) 00550001
FROM V A 00560001
WHERE A.MUT_TIMESTAMP = (SELECT MAX(MUT_TIMESTAMP) 00570001
FROM V B 00580001
WHERE B.VERFALL = A.VERFALL 00590001
AND B.BASISPREIS = A.BASISPREIS 00600001
AND B.KONTRAKT = A.KONTRAKT 00610001
AND B.VERSION = A.VERSION) 00620001
ORDER BY 1, 2, 9, 10, 4, 5, 3, 6 00630001
; 00640001