Question: what are physical joins in sql server?
Answer: Physical Joins: These are the joins that users don't use/write in their SQL queries. Instead these are implemented inside SQL Server engine as operators or algorithms to implement the Logical Joins. Their types are Nested Loop, Merge and Hash.