Improving SQL Query joins performance We have been using SQL Server 2014 for our project as a backend source. We have been performing various joins on the tables. We came across a question in one to many and many to one relationship in joins.

Say for example: I have a table named Industry and another table called Products. Industry holds the list of Industry in market and Products holds that industry's multiple products.

Industry

Id
IndustryName
Owner


Products

Id
IndustryId
ProductId
ProductName

From the above tables, I am performing two queries as shown below:


1 to many

Select *
from Industry
inner join Products 
    on Industry.Id = Product.IndustryId

many to 1

Select * 
from Product
inner join Industry 
    on Product.IndustryId = Industry.Id 



Among the above which will be more efficient performance wise?
No difference. Only the order of the columns in the SELECT list changes.

See related questions: 


Is it correct, order of where clause doesn&#39;t matter when it is used with join?
join syntax / style performance consideration
Is a join optimized to a where clause at runtime?


Changes like this will almost 100% produce the same execution plan.



Communtiy Wiki answer based on an original comment on the question by @ypercube