--- temporary explain --------------------------------------------------00000100
set current sqlid = 'A540769'; 00000200
delete from A540769.plan_table; 00000300
delete from A540769.DSN_STATEMNT_TABLE; 00000400
delete from A540769.DSN_DetCost_TABLE ; 00000500
delete from A540769.dsn_filter_Table ; 00000600
delete from A540769.dsn_predicat_table; 00000700
00000801
EXPLAIN ALL SET QUERYNO = 1 FOR 00003900
( 00004000
SELECT 00004100
SU201_INDEX, 00004200
SU201_PROGRAM_PATH, 00005000
SU201_MODULE_NAME, 00006000
SU201_INFO_OBJECT, 00007000
SU201_VARIANT, 00008000
SU201_LAST_UPDATE, 00009000
SU201_PID, 00009100
SU201_COMMENT 00009200
FROM 00009300
OA1A.TSU201A1 00009400
WHERE 00009500
SU201_PROGRAM_PATH = '/WP5020' OR 00009600
SU201_PROGRAM_PATH IN 00009700
( 00009800
SELECT(SU203_GROUP_PATH) 00009900
FROM 00010000
OA1A.TSU203A1 00010100
WHERE 00010200
SU201_PROGRAM_PATH = '/WP5020' 00010300
) 00010400
) 00010500
UNION 00010600
( 00010700
SELECT 00010800
SU201_INDEX, 00010900
SU201_PROGRAM_PATH, 00011000
SU201_MODULE_NAME, 00011100
SU201_INFO_OBJECT, 00011200
SU201_VARIANT, 00011300
SU201_LAST_UPDATE, 00011400
SU201_PID, 00011500
SU201_COMMENT 00011600
FROM 00011700
OA1A.TSU201A1 00011800
WHERE 00011900
( 00012000
SU201_PROGRAM_PATH = '#Imposed' OR 00012100
SU201_PROGRAM_PATH = '#Default' 00012200
) AND 00012300
SU201_MODULE_NAME = 'YSUSIFM' 00012400
) 00012500
with UR 00012600
; 00012700
EXPLAIN ALL SET QUERYNO = 2 FOR 00013000
( 00020000
SELECT 00030000
SU201_INDEX, 00040000
SU201_PROGRAM_PATH, 00050000
SU201_MODULE_NAME, 00060000
SU201_INFO_OBJECT, 00070000
SU201_VARIANT, 00080000
SU201_LAST_UPDATE, 00090000
SU201_PID, 00100000
SU201_COMMENT 00110000
FROM 00120000
OA1A.TSU201A1 00130000
WHERE 00140000
SU201_PROGRAM_PATH = '/WP5020' 00150000
) 00160000
UNION 00170000
( 00180000
SELECT 00190000
SU201_INDEX, 00200000
SU201_PROGRAM_PATH, 00210000
SU201_MODULE_NAME, 00220000
SU201_INFO_OBJECT, 00230000
SU201_VARIANT, 00240000
SU201_LAST_UPDATE, 00250000
SU201_PID, 00260000
SU201_COMMENT 00270000
FROM 00280000
OA1A.TSU201A1 00290000
WHERE 00300000
( 00310000
SU201_PROGRAM_PATH = '#Imposed' OR 00320000
SU201_PROGRAM_PATH = '#Default' 00330000
) AND 00340000
SU201_MODULE_NAME = 'YSUSIFM' 00350000
) 00360000
with ur 00370000
; 00380000
select * from plan_view1 00400000
order by -- collid, progName, version, bind_time, 00410000
queryNo, qblockno, planno, mixOpSeq 00420000
; 00430000
select * from plan_view2 00440000
order by -- collid, progName, version, bind_time, 00450000
queryNo, qblockno, planno, mixOpSeq 00460000
; 00470000
select * from plan_view2det 00480000
order by -- collid, progName, version, bind_time, 00490000
queryNo, qblockno, planno, mixOpSeq 00500000
; 00510000
select * 00520000
from plan_viewPred 00530000
order by --collid, progName, applName, explain_time, 00540000
queryNo, qBlockNo, planno, 00550000
stage, predNo 00560000
with ur 00570000
; 00580000
rollback 00590000
;;;; 00600000