Lesson Summary

• Be familiar with the common join methods

  • Nested Loops Join
  • Outer Join
  • Sort-Merge Join
  • Hash Join
  • Anti-Join
  • Semi-Join

• Know why the optimizer chooses each

• Know how join order can affect performance

Notes: