# Comparison Of Join Costs In Case Studies

+ `Merge Join (43433168)> Hash Join (5798730) > Index Join (3766726) > Index Hash Join (3572268)`


![left](./student-guide/diagram/01-71-1.png)

------------------------------------------------------------

Judging from the cost of execution: Merge Join (43433168) > Hash Join (5798730) > Index Join (3766726) > Index Hash Join (3572268), so the final optimizer chose Index Hash based on cost evaluation JOIN