--- ausgewählte Explains analysieren 00100001
select * 00110001
-- from cmnbatch.plan_view1 00120001
from cmnbatch.plan_view2 00130001
-- from cmnbatch.plan_view2Det 00140001
where collid = 'SV' 00150001
and progName = 'YSV016G' 00160001
and bind_time in('2012-01-26-09.48.56.445311' 00170007
,'2011-08-12-23.50.33.890848' 00180001
) 00190001
order by collid, progName, version, bind_time, 00200001
queryno, qBlockNo, planno, mixopSeq 00210001
; 00220002
select * 00230002
from cmnbatch.plan_viewPred 00240002
where collid = 'SV' 00250002
and progName = 'YSV016G' 00260002
and bind_time in('2012-01-26-09.48.56.445311' 00270006
,'2011-08-12-23.50.33.890848' 00280002
) 00290002
order by collid, progName, applName, bind_time, 00300002
queryNo, qBlockNo, planno, 00310002
stage, predNo 00320002
with ur 00330002
;; 00340006
--- temporary explain --------------------------------------------------00350006
set current sqlid = 'A540769'; 00360006
delete from A540769.plan_table; 00370006
delete from A540769.DSN_STATEMNT_TABLE; 00380006
delete from A540769.DSN_DetCost_TABLE ; 00390006
delete from A540769.dsn_filter_Table ; 00400006
delete from A540769.dsn_predicat_table; 00410006
explain plan set queryno = 3 for 00420006
SELECT ID, CIFNO, BUID, ORDERNO, TXTYPE, 00430006
BOOKINGDATE, VALUEDATE, ACNO, TXCYCDCS, ACCYCDCS, FUCYCDCS, FEEBESL, 00440006
VATBESL, FEEAMNTTXCY, FEEAMNTACCY, FEEAMNTFUCY, VATAMNTTXCY, 00450006
VATAMNTACCY, VATAMNTFUCY, VATPERCENT, XRATETXFU, XRATETXAC, XRATEACFU, 00460006
PRODUCTCON, PRODUCTNO, PRICEMDMCD, PRICECMPNTNO, MUTATIONTMSTMP, 00470006
MUTATINGINST 00480006
FROM oa1p.TSV016A1 00490006
WHERE CIFNO = ? AND ID > ? AND (VALUEDATE 00500006
>= ? AND VALUEDATE <= ?) ORDER BY ID ASC 00510006
; 00520006
select * from plan_view1 00530006
order by -- collid, progName, version, bind_time, 00540006
queryNo, qblockno, planno, mixOpSeq 00550006
; 00560006
select * from plan_view2 00570006
order by -- collid, progName, version, bind_time, 00580006
queryNo, qblockno, planno, mixOpSeq 00590006
; 00600006
select * from plan_view2det 00610006
order by -- collid, progName, version, bind_time, 00620006
queryNo, qblockno, planno, mixOpSeq 00630006
; 00640006
select * 00650006
from plan_viewPred 00660006
order by --collid, progName, applName, explain_time, 00670006
queryNo, qBlockNo, planno, 00680006
stage, predNo 00690006
with ur 00700006
; 00710006
rollback 00720006
; 00730006
--- versionen, compiles und explains eines packages ------------------ 00740006
select * 00750006
from cmnbatch.plan_view0 00760006
where collid = 'SV' 00770006
and prog = 'YSV016G' 00780006
order by pcBi desc, bind_Time desc 00790006
with ur 00800006
;;; 00810006