Database Reference
In-Depth Information
Access Path: index (AllEqJoinGuess)
Index: EMP_DEPARTMENT_IX
resc_io: 1.00 resc_cpu: 13471
ix_sel: 0.091767 ix_sel_with_filters: 0.091767
NL Join: Cost: 4.65 Resp: 4.65 Degree: 1
Cost_io: 4.63 Cost_cpu: 52993
Resp_io: 4.63 Resp_cpu: 52993
Best NL cost: 4.65
resc: 4.65 resc_io: 4.63 resc_cpu: 52993
resp: 4.65 resp_io: 4.63 resp_cpu: 52993
Join Card: 15.14 = outer (3.86) * inner (107.00) * sel (0.036691)
Join Card - Rounded: 15 Computed: 15.14
SM Join
Outer table:
resc: 3.01 card 3.86 bytes: 67 deg: 1 resp: 3.01
Inner table: EMPLOYEES Alias: EMP
resc: 3.02 card: 107.00 bytes: 66 deg: 1 resp: 3.02
using dmeth: 2 #groups: 1
SORT resource Sort statistics
Sort width: 138 Area size: 131072 Max Area size: 24536064
Degree: 1
Blocks to Sort: 1 Row size: 84 Total Rows: 4
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 3356360
Total Temp space used: 0
SORT resource Sort statistics
Sort width: 138 Area size: 131072 Max Area size: 24536064
Degree: 1
Blocks to Sort: 2 Row size: 83 Total Rows: 107
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 3388500
Total Temp space used: 0
SM join: Resc: 8.04 Resp: 8.04 [multiMatchCost=0.00]
SM cost: 8.04
resc: 8.04 resc_io: 6.00 resc_cpu: 6842201
resp: 8.04 resp_io: 6.00 resp_cpu: 6842201
HA Join
Outer table:
resc: 3.01 card 3.86 bytes: 67 deg: 1 resp: 3.01
Inner table: EMPLOYEES Alias: EMP
resc: 3.02 card: 107.00 bytes: 66 deg: 1 resp: 3.02
using dmeth: 2 #groups: 1
Cost per ptn: 0.50 #ptns: 1
hash_area: 0 (max=0) Hash join: Resc: 6.53 Resp: 6.53 [multiMatchCost=0.00]
