Database Reference
In-Depth Information
GROUP BY sort
ColGroup Usage:: PredCnt: 3 Matches Full: Partial:
GROUP BY adjustment factor: 0.500000
GROUP BY cardinality: 150.000000, TABLE cardinality: 42592863.000000
SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 245087 Row size: 47 Total Rows: 42592863
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 48667303854
Total Temp space used: 0
Best:: JoinMethod: Hash
Cost: 259483.29 Degree: 1 Resp: 259483.29 Card: 42592862.72 Bytes: 33
***********************
Best so far: Table#:0 cost:5458.2261 card: 4299997.0000 bytes: 47299967
Table#:1 cost:259483.2873 card: 42592862.7173 bytes: 1405564479
***********************
Join order[2]: ORDER_LINE[OL]#1 ORDERS[ORD]#0
***************
Now joining: ORDERS[ORD]#0
***************
NL Join
Outer table: Card: 42998248.00 Cost: 178428.72 Resp: 178428.72 Degree: 1 Bytes: 22
Access path analysis for ORDERS
Inner table: ORDERS Alias: ORD
Access Path: TableScan
NL Join: Cost: 249713973874.97 Resp: 249713973874.97 Degree: 1
Cost_io: 248407327395.00 Cost_cpu: 41661307584008368
Resp_io: 248407327395.00 Resp_cpu: 41661307584008368
Access Path: index (index (FFS))
Index: ORDERS_I1
resc_io: 9870.79 resc_cpu: 780458762
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: ORDERS Alias: ORD
Access Path: index (FFS)
NL Join: Cost: 425479435734.14 Resp: 425479435734.14 Degree: 1
Cost_io: 424426926161.00 Cost_cpu: 33558369255887276
Resp_io: 424426926161.00 Resp_cpu: 33558369255887276
Access Path: index (index (FFS))
Index: ORDERS_I2
resc_io: 5435.90 resc_cpu: 644891062
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Inner table: ORDERS Alias: ORD
Access Path: index (FFS)
NL Join: Cost: 234603861264.23 Resp: 234603861264.23 Degree: 1
Cost_io: 233734175265.00 Cost_cpu: 27729195670497676
Resp_io: 233734175265.00 Resp_cpu: 27729195670497676
Access Path: index (UniqueScan)
Index: ORDERS_I1
resc_io: 1.00 resc_cpu: 9021
Search WWH ::
Custom Search