I have two tables which are JOINed together in a azure video
dp-300-database-admin-assoc video for 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
Answer
          Full Certification Question
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?