What is logical and physical join in sql server

Dilshad Ali

7y2.5k

What is logical and physical join in sql server.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar4y ago
Hi Silshad Ali,

Please refer this blog where its explained well which may help you,
https://www.c-sharpcorner.com/blogs/physical-join-vs-logical-join-in-sql-server
+1
geetha geetha4y ago
Logical Joins:
Logical joins are simple joins we apply on sql queries.logical joins are,
Inner join
Outer join
Left outer Right Outer join
Full outer join
Physical joins:
User did'nt write the sql query for physical join, instead of we implement in sql server engine or operators or algorithms.
Here i attached the example of logical join.

+2
Rajanikant Hawaldar6y ago
Physical joins are the ones, which will be used by sql Server internally. You will not write queries with them unless you explicitly specify with Hints. Logical joins: Inner join, Outer join, Full join, Cross join, Apply operators Physical Joins: Merge join, Hash join
+1
Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://sqlwithmanoj.com/2010/10/06/physical-join-vs-logical-join/
+1
Harsh Shah7y ago
Hi Dilshad,
please refer below answer.

Logical join: Inner Join, Left outer join, Cross Join, Outer apply. This joins are written by 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.

Hope this will help you.
Thank you.
+1
Sonu Gupta7y ago
Hi,

Visit the following URL-

https://sqlwithmanoj.com/2010/10/06/physical-join-vs-logical-join/
+1
Jaimin Shethiya7y ago
Hello Dilshad,

Can you please check the below brief description for logical and physical join in sql.

1. Logical Joins: These joins are simple joins that we apply in our SQL queries, like INNER JOIN, RIGHT/LEFT OUTER JOIN, CROSS JOIN, OUTER APPLY, etc.

2. 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.

Thanks
+1