<br />Nested LOOP ( e.g : 260 rows * 1 rows)<br />- FOR (small set data)<br />          FOR(big set data)<br /> <br />Hash Join (e.g : 190 rows * 19000 rows)<br />- build input - small data data - Join column will be hashed<br />- probe input - bigger data