Logical Joins and Physical Joins

Logical Joins: INNER JOIN, RIGHT/LEFT OUTER JOIN, CROSS JOIN, OUTER APPLY. This joins are written by the user.

Physical Joins: Nested loop, merge join and hash join is common operators which we will see in execution plan as long as query contains any logical joins (inner join, outer join, cross join, semi join). These three joins are called Physical Joins.

In below example I have executed query against AdventureWorks database with Inner Join. You can see the Nested Join in Execution Plan.

2 thoughts on “Logical Joins and Physical Joins

  1. Anjali Gupta

    Hi Jugal Sir,

    I am the regular reader of you blog. It took 3 months for me to read your all posts. The best thing about your blog is you are writing in the form which will be understable by Novice DBA as well.

    I would like to share my experience with everyone that, I got a DBA job which is my dream with the best salary.

    Thank You Very Much for your posting

    God Bless you Sir

    Anjali Gupta


Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s