Watch this video on YouTube
I have two tables which are JOINed together in a table. The first table is small, and the second is large and has an index on the join. Which join type will probably be used by the SQL Server query optimizer?