SQL SERVER Execution Plan - Which Join is Expensive and Which Join is Faster ?

Sep 7 2010 6:04 AM

In the sql server execution plan, there were different types of joins like Hash, Merge & Loop. Can any one tell me which join will take longer time and which one will take less time to execute ?