Database Reference
In-Depth Information
ix_sel: 0.000000 ix_sel_with_filters: 0.000000
NL Join (ordered): Cost: 4950360.85 Resp: 4950360.85 Degree: 1
Cost_io: 4947075.00 Cost_cpu: 104766394419
Resp_io: 4947075.00 Resp_cpu: 104766394419
Best NL cost: 4950360.85
resc: 4950360.85 resc_io: 4947075.00 resc_cpu: 104766394419
resp: 4950360.85 resp_io: 4947075.00 resc_cpu: 104766394419
Join selectivity using 1 ColGroups: 0.000000 (sel1 = 0.000000, sel2 = 0.000000)
Join Card: 42592862.717274 = = outer (4299997.000000) * inner (42998248.000000) * sel (0.000000)
Join Card - Rounded: 42592863 Computed: 42592862.72
Grouping column cardinality [ OL_NUMBER] 15
Grouping column cardinality [ OL_W_ID] 2
Grouping column cardinality [ OL_D_ID] 10
Outer table: ORDERS Alias: ORD
resc: 5458.23 card 4299997.00 bytes: 11 deg: 1 resp: 5458.23
Inner table: ORDER_LINE Alias: OL
resc: 178428.72 card: 42998248.00 bytes: 22 deg: 1 resp: 178428.72
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 12109 Row size: 23 Total Rows: 4299997
Initial runs: 2 Merge passes: 1 IO Cost / pass: 6560
Total IO sort cost: 18669 Total CPU sort cost: 4599195307
Total Temp space used: 207234000
SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 184249 Row size: 35 Total Rows: 42998248
Initial runs: 2 Merge passes: 1 IO Cost / pass: 99804
Total IO sort cost: 284053 Total CPU sort cost: 53693990840
Total Temp space used: 3453363000
SM join: Resc: 488437.23 Resp: 488437.23 [multiMatchCost=0.00]
SM Join
SM cost: 488437.23
resc: 488437.23 resc_io: 486280.00 resc_cpu: 68781395928
resp: 488437.23 resp_io: 486280.00 resp_cpu: 68781395928
Outer table: ORDERS Alias: ORD
resc: 5458.23 card 4299997.00 bytes: 11 deg: 1 resp: 5458.23
Inner table: ORDER_LINE Alias: OL
resc: 178428.72 card: 42998248.00 bytes: 22 deg: 1 resp: 178428.72
using dmeth: 2 #groups: 1
Cost per ptn: 74069.96 #ptns: 1
hash_area: 256 (max=262144) buildfrag: 12073 probefrag: 178460 ppasses: 1
Hash join: Resc: 257956.91 Resp: 257956.91 [multiMatchCost=0.00]
HA Join
HA cost: 257956.91
resc: 257956.91 resc_io: 257313.00 resc_cpu: 20530453418
resp: 257956.91 resp_io: 257313.00 resp_cpu: 20530453418
Search WWH ::




Custom Search