回复 2# mdkii ows Operator
(ID)
Cost
51694.8
INSERT
( 2)
1.02651e+06
/ \
51694.8 2.26548e+06
TBSCAN Table:
( 3) RFMA
970657 FDM_PA_AC
|
51694.8
TEMP
( 4)
970611
|
51694.8
UPDATE
( 5)
970587
/---/ \
51694.8 2.26548e+06
FETCH Table:
( 6) RFMA
579606 FDM_PA_AC
/--/ \
51694.8 2.26548e+06
NLJOIN Table:
( 7) RFMA
188599 FDM_PA_AC
/-/ \
646185 0.08
FILTER UNION
( 8) (29)
187357 0.00173938
| / \
646185 0.04 0.04
TBSCAN FILTER FILTER
( 9) (30) (32)
186258 0.000692988 0.000692988
| | |
646185 1 1
SORT TBSCAN TBSCAN
(10) (31) (33)
186197 4.58174e-05 4.58174e-05
| | |
646185 TFunc: TFunc:
HSJOIN SYSIBM SYSIBM
(11) GENROW GENROW
185259
/----/ \-------\
2.26548e+06 646185
TBSCAN TBSCAN
(12) (13)
173128 11138.4
| |
2.26548e+06 646185
Table: TEMP
RFMA (14)
FDM_PA_AC 10562.3
|
646185
GRPBY
(15)
10156.4
|
646185
HSJOIN
(16)
10094.7
/-----/ \----\
701156 238.694
NLJOIN FILTER
(17) (26)
6426.21 3549.91
/ \ |
2142.52 327.258 259
FILTER IXSCAN GRPBY
(18) (25) (27)
103.346 40.2143 3549.75
| | |
2231.79 2.26548e+06 2.19525e+06
GRPBY Index: IXSCAN
(19) RFMA (28)
102.588 IDX509100649080000 3340.21
| |
2231.79 516082
TBSCAN Index:
(20) RFMA
102.375 IDX509100646550000
|
2231.79
SORT
(21)
102.161
|
2231.79
NLJOIN
(22)
99.9131
/ \
2 1115.89
TBSCAN IXSCAN
(23) (24)
5.72717e-05 49.964
| |
TFunc: 82998
SYSIBM Index:
GENROW RFMA
IDX509100648570000