zOs/TX/PA2DIEXP
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 10 for
select d.* from
qz92crT.tqz91pa2diPart p join qz92crT.tqz91pa2diData d
on p.p = d.p and d.cif >= p.cifBeg and d.cif < p.cifEnd
and d.aDt >= p.aDtBeg and d.aDt < p.aDtEnd
where d.cif = 'C_PG'
and d.aDt = '25.04.2016'
;
explain plan set queryno = 12 for
select d.* from
qz92crT.tqz91pa2diPart p join qz92crT.tqz91pa2diData d
on p.p = d.p and d.cif >= p.cifBeg and d.cif < p.cifEnd
and d.aDt >= p.aDtBeg and d.aDt < p.aDtEnd
where d.cif = 'C_PG'
and d.aDt = '25.04.2016'
and p.cifBeg <= 'C_PG' and p.cifEnd > 'C_PG'
and p.aDtBeg <= '25.04.2016' and p.aDtEnd > '25.04.2016'
;
explain plan set queryno = 20 for
select d.* from
qz92crT.tqz91pa2diPart p join qz92crT.tqz91pa2diData d
on p.p = d.p and d.cif >= p.cifBeg and d.cif < p.cifEnd
and d.aDt >= p.aDtBeg and d.aDt < p.aDtEnd
where d.cif = 'C_PG'
and d.aDt >= '25.04.2016' and d.aDt < '04.05.2016'
;
explain plan set queryno = 30 for
select d.* from
qz92crT.tqz91pa2diPart p join qz92crT.tqz91pa2diData d
on p.p = d.p and d.cif >= p.cifBeg and d.cif < p.cifEnd
and d.aDt >= p.aDtBeg and d.aDt < p.aDtEnd
where d.cif >= 'CS' and d.cif < 'DB'
and d.aDt >= '25.04.2016' and d.aDt < '04.05.2016'
;
explain plan set queryno = 32 for
select d.* from
qz92crT.tqz91pa2diPart p join qz92crT.tqz91pa2diData d
on p.p = d.p and d.cif >= p.cifBeg and d.cif < p.cifEnd
and d.aDt >= p.aDtBeg and d.aDt < p.aDtEnd
where d.cif >= 'CS' and d.cif < 'DB'
and d.aDt >= '25.04.2016' and d.aDt < '04.05.2016'
and p.cifEnd > 'CS' and p.cifBeg < 'DB'
and p.aDtEnd > '25.04.2016' and p.aDtBeg < '04.05.2016'
;
explain plan set queryno = 34 for
select d.*
from qz92crT.tqz91pa2diData d
where d.cif >= 'CS' and d.cif < 'DB'
and d.aDt >= '25.04.2016' and d.aDt < '04.05.2016'
and d.p in (select p.p
from qz92crT.tqz91pa2diPart p
where p.cifEnd > 'CS' and p.cifBeg < 'DB'
and p.aDtEnd > '25.04.2016' and p.aDtBeg < '04.05.2016'
)
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
rollback
$#out 20160612 15:24:58
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
SQLCODE = -199: ILLEGAL USE OF KEYWORD WHERE. TOKEN
SELECTIVITY AND OR HAVING GROUP INTERSECT ORDER FETCH EXCEPT WAS
EXPECTED
src ... d.aDt < '04.05.2016' and d.p in (select p.p from qz92crT.tqz91pa
+ 2diPart p where p.cifEnd > 'CS' and p.cifBeg < 'DB' and p.aDtEnd > '
+ 25.04.2016' and p.aDtBeg < '04.05.2016' ) where d.cif >= 'CS' and...
> >>>pos 728 of 853>>>
sql = explain plan set queryno = 34 for ...
sqlCode 0: rollback
$#out 20160612 15:17:15
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
10 rows fetched: select * from plan_view1 order by queryNo, qblockno, plan...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
10 rows fetched: select * from plan_view2 order by queryNo, qblockno, plan...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
2.17e0 2.17e0 0.0e0 4.08e-2 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 1.24e-1 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
10 rows fetched: select * from plan_view2det order by queryNo, qblockno, p...
Queryn B PM TEXT ...
PREDIN ...
ORDERN ...
STAGE ...
FF ...
PRTY ...
BoN ...
Queryn B PM PR ORD STAGE FF PRTY BoN TEXT ...
10 1 1 --- --- 1.00e00 AND Y N (((((("D"."CIF"='C_PG' AND...
10 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
10 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
10 1 20 4 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
10 1 20 5 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
10 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
10 1 20 7 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
10 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
10 1 9 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8 ...
10 1 10 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
10 1 11 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8 ...
10 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
12 1 1 --- --- 1.00e00 AND Y N (((((((((("D"."CIF"='C_PG'...
12 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
12 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
12 1 10 4 1 MATCHING 6.00e-1 RANGE Y N "P"."CIFBEG"<='C_PG' ...
12 1 10 5 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'C_PG' ...
12 1 10 6 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<='2016-04-25'...
12 1 10 7 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
12 1 20 8 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
12 1 20 9 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
12 1 20 10 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
12 1 20 11 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
12 1 20 12 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
12 1 13 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
12 1 14 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 4,5,6,7,9 ...
12 1 15 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8,9,10,1...
12 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8 ...
12 1 17 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8,9,10,11,12...
12 1 18 --- --- 3.61e-2 COMPOUND Y N COMPOUND: 4,5,6,7 ...
20 1 1 --- --- 1.00e00 AND Y N ((((((("D"."CIF"='C_PG' AN...
20 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
20 1 20 3 3 MATCHING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
20 1 20 4 4 MATCHING 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
20 1 20 5 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
20 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
20 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
20 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
20 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
20 1 10 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
20 1 11 --- --- 1.60e-4 COMPOUND Y N COMPOUND: 2,5 ...
20 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,8,9 ...
20 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
20 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 5,6,7,8,9 ...
20 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9 ...
30 1 1 --- --- 1.00e00 AND Y N (((((((("D"."CIF">='CS' AN...
30 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
30 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
30 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
30 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
30 1 20 6 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
30 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
30 1 20 8 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
30 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
30 1 20 10 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
30 1 11 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
30 1 12 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
30 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9,...
30 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10 ...
30 1 15 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,6 ...
30 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6 ...
32 1 1 --- --- 1.00e00 AND Y N (((((((((((("D"."CIF">='CS...
32 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
32 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
32 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
32 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
32 1 10 6 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'CS' ...
32 1 10 7 1 MATCHING 8.00e-1 RANGE Y N "P"."CIFBEG"<'DB' ...
32 1 10 8 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
32 1 10 9 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<'2016-05-04' ...
32 1 20 10 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
32 1 20 11 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
32 1 20 12 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
32 1 20 13 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
32 1 20 14 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
32 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
32 1 16 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10,11,12...
32 1 17 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
32 1 18 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 6,7,8,9,11 ...
32 1 19 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,10 ...
32 1 20 --- --- 4.28e-2 COMPOUND Y N COMPOUND: 6,7,8,9 ...
32 1 21 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10,11,12...
32 1 22 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10 ...
83 rows fetched: select * from plan_viewPred order by collid, progName, ex...
sqlCode 0: rollback
$#out 20160612 15:16:00
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
10 rows fetched: select * from plan_view1 order by queryNo, qblockno, plan...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
10 rows fetched: select * from plan_view2 order by queryNo, qblockno, plan...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
2.17e0 2.17e0 0.0e0 4.08e-2 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 1.24e-1 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
10 rows fetched: select * from plan_view2det order by queryNo, qblockno, p...
SQLCODE = -104: ILLEGAL SYMBOL "FRXM". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: FROM INTO
src select * frxm plan_viewPred orde...
> >>>pos 77 of 299>>>
sql = select * ...
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
sqlCode 0: rollback
$#out 20160612 15:15:39
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
10 rows fetched: select * from plan_view1 order by queryNo, qblockno, plan...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
10 rows fetched: select * from plan_view2 order by queryNo, qblockno, plan...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
2.17e0 2.17e0 0.0e0 4.08e-2 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 1.24e-1 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
10 rows fetched: select * from plan_view2det order by queryNo, qblockno, p...
SQLCODE = -104: ILLEGAL SYMBOL "FRXM". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: FROM INTO
src select * frxm plan_viewPred orde...
> >>>pos 77 of 299>>>
sql = select * ...
stmt = prepare s10 into :M.SQL.10.D from :src
with into :M.SQL.10.D = M.SQL.10.D
sqlCode 0: rollback
$#out 20160612 15:14:22
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
10 rows fetched: select * from plan_view1 order by queryNo, qblockno, plan...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
10 rows fetched: select * from plan_view2 order by queryNo, qblockno, plan...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
2.17e0 2.17e0 0.0e0 4.08e-2 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 1.24e-1 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
10 rows fetched: select * from plan_view2det order by queryNo, qblockno, p...
Queryn B PM TEXT ...
PREDIN ...
ORDERN ...
STAGE ...
FF ...
PRTY ...
BoN ...
Queryn B PM PR ORD STAGE FF PRTY BoN TEXT ...
10 1 1 --- --- 1.00e00 AND Y N (((((("D"."CIF"='C_PG' AND...
10 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
10 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
10 1 20 4 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
10 1 20 5 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
10 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
10 1 20 7 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
10 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
10 1 9 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8 ...
10 1 10 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
10 1 11 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8 ...
10 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
12 1 1 --- --- 1.00e00 AND Y N (((((((((("D"."CIF"='C_PG'...
12 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
12 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
12 1 10 4 1 MATCHING 6.00e-1 RANGE Y N "P"."CIFBEG"<='C_PG' ...
12 1 10 5 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'C_PG' ...
12 1 10 6 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<='2016-04-25'...
12 1 10 7 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
12 1 20 8 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
12 1 20 9 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
12 1 20 10 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
12 1 20 11 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
12 1 20 12 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
12 1 13 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
12 1 14 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 4,5,6,7,9 ...
12 1 15 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8,9,10,1...
12 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8 ...
12 1 17 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8,9,10,11,12...
12 1 18 --- --- 3.61e-2 COMPOUND Y N COMPOUND: 4,5,6,7 ...
20 1 1 --- --- 1.00e00 AND Y N ((((((("D"."CIF"='C_PG' AN...
20 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
20 1 20 3 3 MATCHING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
20 1 20 4 4 MATCHING 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
20 1 20 5 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
20 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
20 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
20 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
20 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
20 1 10 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
20 1 11 --- --- 1.60e-4 COMPOUND Y N COMPOUND: 2,5 ...
20 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,8,9 ...
20 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
20 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 5,6,7,8,9 ...
20 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9 ...
30 1 1 --- --- 1.00e00 AND Y N (((((((("D"."CIF">='CS' AN...
30 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
30 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
30 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
30 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
30 1 20 6 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
30 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
30 1 20 8 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
30 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
30 1 20 10 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
30 1 11 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
30 1 12 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
30 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9,...
30 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10 ...
30 1 15 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,6 ...
30 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6 ...
32 1 1 --- --- 1.00e00 AND Y N (((((((((((("D"."CIF">='CS...
32 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
32 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
32 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
32 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
32 1 10 6 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'CS' ...
32 1 10 7 1 MATCHING 8.00e-1 RANGE Y N "P"."CIFBEG"<'DB' ...
32 1 10 8 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
32 1 10 9 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<'2016-05-04' ...
32 1 20 10 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
32 1 20 11 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
32 1 20 12 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
32 1 20 13 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
32 1 20 14 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
32 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
32 1 16 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10,11,12...
32 1 17 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
32 1 18 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 6,7,8,9,11 ...
32 1 19 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,10 ...
32 1 20 --- --- 4.28e-2 COMPOUND Y N COMPOUND: 6,7,8,9 ...
32 1 21 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10,11,12...
32 1 22 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10 ...
83 rows fetched: select * from plan_viewPred order by collid, progName, ex...
sqlCode 0: rollback
$#out 20160610 13:31:11
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
10 rows fetched: select * from plan_view1 order by queryNo, qblockno, plan...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
10 rows fetched: select * from plan_view2 order by queryNo, qblockno, plan...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
2.17e0 2.17e0 0.0e0 4.08e-2 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 1.24e-1 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
10 rows fetched: select * from plan_view2det order by queryNo, qblockno, p...
Queryn B PM TEXT ...
PREDIN ...
ORDERN ...
STAGE ...
FF ...
PRTY ...
BoN ...
Queryn B PM PR ORD STAGE FF PRTY BoN TEXT ...
10 1 1 --- --- 1.00e00 AND Y N (((((("D"."CIF"='C_PG' AND...
10 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
10 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
10 1 20 4 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
10 1 20 5 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
10 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
10 1 20 7 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
10 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
10 1 9 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8 ...
10 1 10 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
10 1 11 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8 ...
10 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
12 1 1 --- --- 1.00e00 AND Y N (((((((((("D"."CIF"='C_PG'...
12 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
12 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
12 1 10 4 1 MATCHING 6.00e-1 RANGE Y N "P"."CIFBEG"<='C_PG' ...
12 1 10 5 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'C_PG' ...
12 1 10 6 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<='2016-04-25'...
12 1 10 7 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
12 1 20 8 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
12 1 20 9 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
12 1 20 10 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
12 1 20 11 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
12 1 20 12 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
12 1 13 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
12 1 14 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 4,5,6,7,9 ...
12 1 15 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8,9,10,1...
12 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8 ...
12 1 17 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,8,9,10,11,12...
12 1 18 --- --- 3.61e-2 COMPOUND Y N COMPOUND: 4,5,6,7 ...
20 1 1 --- --- 1.00e00 AND Y N ((((((("D"."CIF"='C_PG' AN...
20 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
20 1 20 3 3 MATCHING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
20 1 20 4 4 MATCHING 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
20 1 20 5 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
20 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
20 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
20 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
20 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
20 1 10 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
20 1 11 --- --- 1.60e-4 COMPOUND Y N COMPOUND: 2,5 ...
20 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,8,9 ...
20 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
20 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 5,6,7,8,9 ...
20 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9 ...
30 1 1 --- --- 1.00e00 AND Y N (((((((("D"."CIF">='CS' AN...
30 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
30 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
30 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
30 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
30 1 20 6 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
30 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
30 1 20 8 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
30 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
30 1 20 10 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
30 1 11 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
30 1 12 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
30 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9,...
30 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10 ...
30 1 15 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,6 ...
30 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6 ...
32 1 1 --- --- 1.00e00 AND Y N (((((((((((("D"."CIF">='CS...
32 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
32 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
32 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
32 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
32 1 10 6 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'CS' ...
32 1 10 7 1 MATCHING 8.00e-1 RANGE Y N "P"."CIFBEG"<'DB' ...
32 1 10 8 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
32 1 10 9 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<'2016-05-04' ...
32 1 20 10 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
32 1 20 11 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
32 1 20 12 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
32 1 20 13 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
32 1 20 14 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
32 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
32 1 16 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10,11,12...
32 1 17 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
32 1 18 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 6,7,8,9,11 ...
32 1 19 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,10 ...
32 1 20 --- --- 4.28e-2 COMPOUND Y N COMPOUND: 6,7,8,9 ...
32 1 21 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10,11,12...
32 1 22 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10 ...
83 rows fetched: select * from plan_viewPred order by collid, progName, ex...
sqlCode 0: rollback
$#out 20160610 13:30:25
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
SQLCODE = -206: P.ADBEND IS NOT VALID IN THE CONTEXT WHERE
IT IS USED
sql = explain plan set queryno = 12 for ...
sqlCode 0: rollback
$#out 20160610 13:29:41
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
SQLCODE = -206: D.ADTBEG IS NOT VALID IN THE CONTEXT WHERE
IT IS USED
sql = explain plan set queryno = 12 for ...
sqlCode 0: rollback
$#out 20160610 13:04:35
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 32 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNNN ...
32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
8 rows fetched: select * from plan_view1 order by queryNo, qblockno, plann...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 10 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 10 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 20 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 20 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 30 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 30 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
1 32 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 1Y NNN...
1 32 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
8 rows fetched: select * from plan_view2 order by queryNo, qblockno, plann...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 10 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 10 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 20 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 20 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 30 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 30 1 20 SELECT ixScan IQZ91PA2DIDA...
2.57e0 2.57e0 0.0e0 4.83e-2 0.0e0 32 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.15e-1 0.0e0 32 1 20 SELECT ixScan IQZ91PA2DIDA...
8 rows fetched: select * from plan_view2det order by queryNo, qblockno, pl...
Queryn B PM TEXT ...
PREDIN ...
ORDERN ...
STAGE ...
FF ...
PRTY ...
BoN ...
Queryn B PM PR ORD STAGE FF PRTY BoN TEXT ...
10 1 1 --- --- 1.00e00 AND Y N (((((("D"."CIF"='C_PG' AND...
10 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
10 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
10 1 20 4 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
10 1 20 5 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
10 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
10 1 20 7 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
10 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
10 1 9 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8 ...
10 1 10 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
10 1 11 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8 ...
10 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
20 1 1 --- --- 1.00e00 AND Y N ((((((("D"."CIF"='C_PG' AN...
20 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
20 1 20 3 3 MATCHING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
20 1 20 4 4 MATCHING 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
20 1 20 5 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
20 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
20 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
20 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
20 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
20 1 10 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
20 1 11 --- --- 1.60e-4 COMPOUND Y N COMPOUND: 2,5 ...
20 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,8,9 ...
20 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
20 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 5,6,7,8,9 ...
20 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9 ...
30 1 1 --- --- 1.00e00 AND Y N (((((((("D"."CIF">='CS' AN...
30 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
30 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
30 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
30 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
30 1 20 6 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
30 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
30 1 20 8 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
30 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
30 1 20 10 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
30 1 11 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
30 1 12 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
30 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9,...
30 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10 ...
30 1 15 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,6 ...
30 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6 ...
32 1 1 --- --- 1.00e00 AND Y N (((((((((((("D"."CIF">='CS...
32 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
32 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
32 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
32 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
32 1 10 6 2 SCREENING 3.33e-1 RANGE Y N "P"."CIFEND">'CS' ...
32 1 10 7 1 MATCHING 8.00e-1 RANGE Y N "P"."CIFBEG"<'DB' ...
32 1 10 8 4 SCREENING 3.33e-1 RANGE Y N "P"."ADTEND">'2016-04-25' ...
32 1 10 9 3 SCREENING 3.33e-1 RANGE Y N "P"."ADTBEG"<'2016-05-04' ...
32 1 20 10 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
32 1 20 11 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
32 1 20 12 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
32 1 20 13 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
32 1 20 14 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
32 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
32 1 16 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10,11,12...
32 1 17 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
32 1 18 --- --- 1.94e-2 COMPOUND Y N COMPOUND: 6,7,8,9,11 ...
32 1 19 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,10 ...
32 1 20 --- --- 4.28e-2 COMPOUND Y N COMPOUND: 6,7,8,9 ...
32 1 21 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10,11,12...
32 1 22 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,10 ...
65 rows fetched: select * from plan_viewPred order by collid, progName, ex...
sqlCode 0: rollback
$#out 20160610 13:03:43
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 10 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 20 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 30 for select d.* from qz92crT.tqz91...
SQLCODE = -206: P.CIF IS NOT VALID IN THE CONTEXT WHERE IT
IS USED
sql = explain plan set queryno = 32 for ...
sqlCode 0: rollback
$#out 20160610 13:00:45
sqlCode 0: set current sqlid = 'A540769'
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.plan_table
sqlCode 0, 16 rows deleted: delete from A540769.plan_table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_STATEMNT_TABLE
sqlCode 0, 4 rows deleted: delete from A540769.DSN_STATEMNT_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.DSN_DetCost_TABLE
sqlCode 0, 16 rows deleted: delete from A540769.DSN_DetCost_TABLE
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_filter_Table
sqlCode 0, 25 rows deleted: delete from A540769.dsn_filter_Table
SQLCODE = 000, SUCCESSFUL EXECUTION
warnings 4=W no where
sql = delete from A540769.dsn_predicat_table
sqlCode 0, 100 rows deleted: delete from A540769.dsn_predicat_table
sqlCode 0: explain plan set queryno = 11 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 12 for select d.* from qz92crT.tqz91...
sqlCode 0: explain plan set queryno = 22 for select d.* from qz92crT.tqz91...
Queryn B PM TABLE UJOG ...
TYPE tTy no cor ...
ACCESS mcO ...
INDEX join/met ...
Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJOG ...
11 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
11 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNNN ...
22 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNNN ...
22 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNNN ...
6 rows fetched: select * from plan_view1 order by queryNo, qblockno, plann...
MSEC TABLE ...
Queryn B PM tTy no cor ...
TYPE mcO ...
ACCESS join/met ...
INDEX UJO...
M Queryn B PM TYPE ACCESS INDEX TABLE tTy no c mcO join/m UJO...
2 11 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
2 11 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 12 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 12 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 3N nlJoin NNN...
1 22 1 10 SELECT ixScan IQZ91PA2DIPA TQZ91PA2DIPA tb 1 P 0Y NNN...
1 22 1 20 SELECT ixScan IQZ91PA2DIDA TQZ91PA2DIDA tb 2 D 2N nlJoin NNN...
6 rows fetched: select * from plan_view2 order by queryNo, qblockno, plann...
DMROWS OPENCOST INDEX ...
RDSROW Queryn B PM ...
SNROWS TYPE ...
COMPCOST ACCESS ...
DMROWS RDSROW SNROWS COMPCOST OPENCO Queryn B PM TYPE ACCESS INDEX ...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 11 1 10 SELECT ixScan IQZ91PA2DIPA...
2.36e0 2.36e0 0.0e0 2.50e00 0.0e0 11 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 12 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 2.28e00 0.0e0 12 1 20 SELECT ixScan IQZ91PA2DIDA...
6.00e1 6.00e1 0.0e0 1.85e-1 0.0e0 22 1 10 SELECT ixScan IQZ91PA2DIPA...
1.00e0 1.00e0 0.0e0 1.75e00 0.0e0 22 1 20 SELECT ixScan IQZ91PA2DIDA...
6 rows fetched: select * from plan_view2det order by queryNo, qblockno, pl...
Queryn B PM TEXT ...
PREDIN ...
ORDERN ...
STAGE ...
FF ...
PRTY ...
BoN ...
Queryn B PM PR ORD STAGE FF PRTY BoN TEXT ...
11 1 1 --- --- 1.00e00 AND Y N (((((("D"."CIF"='C_PG' AND...
11 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
11 1 20 3 3 MATCHING 3.28e-2 EQUAL Y N "D"."ADT"='2016-04-25' ...
11 1 20 4 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
11 1 20 5 4 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
11 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
11 1 20 7 6 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
11 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
11 1 9 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8 ...
11 1 10 --- --- 3.20e-4 COMPOUND Y N COMPOUND: 2,3 ...
11 1 11 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 4,5,6,7,8 ...
11 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
12 1 1 --- --- 1.00e00 AND Y N ((((((("D"."CIF"='C_PG' AN...
12 1 20 2 2 MATCHING 9.62e-3 EQUAL Y N "D"."CIF"='C_PG' ...
12 1 20 3 3 MATCHING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
12 1 20 4 4 MATCHING 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
12 1 20 5 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
12 1 20 6 5 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
12 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
12 1 20 8 7 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
12 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
12 1 10 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
12 1 11 --- --- 1.60e-4 COMPOUND Y N COMPOUND: 2,5 ...
12 1 12 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,8,9 ...
12 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4 ...
12 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 5,6,7,8,9 ...
12 1 15 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9 ...
22 1 1 --- --- 1.00e00 AND Y N (((((((("D"."CIF">='CS' AN...
22 1 20 2 2 MATCHING 1.00e-1 RANGE Y N "D"."CIF">='CS' ...
22 1 20 3 3 MATCHING 1.00e-1 RANGE Y N "D"."CIF"<'DB' ...
22 1 20 4 4 SCREENING 3.33e-1 RANGE Y N "D"."ADT">='2016-04-25' ...
22 1 20 5 5 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<'2016-05-04' ...
22 1 20 6 1 MATCHING 1.67e-2 EQUAL Y N "P"."P"="D"."P" ...
22 1 20 7 6 STAGE1 1.00e-1 RANGE Y N "D"."CIF">="P"."CIFBEG" ...
22 1 20 8 7 STAGE1 1.00e-1 RANGE Y N "D"."CIF"<"P"."CIFEND" ...
22 1 20 9 8 STAGE1 3.33e-1 RANGE Y N "D"."ADT">="P"."ADTBEG" ...
22 1 20 10 9 STAGE1 3.33e-1 RANGE Y N "D"."ADT"<"P"."ADTEND" ...
22 1 11 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5 ...
22 1 12 --- --- 1.00e-2 COMPOUND Y N COMPOUND: 2,3 ...
22 1 13 --- --- 2.23e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6,7,8,9,...
22 1 14 --- --- 1.67e-2 COMPOUND Y N COMPOUND: 6,7,8,9,10 ...
22 1 15 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,6 ...
22 1 16 --- --- 5.25e-6 COMPOUND Y N COMPOUND: 2,3,4,5,6 ...
43 rows fetched: select * from plan_viewPred order by collid, progName, ex...
sqlCode 0: rollback
$#out