SQL Server To Join or Not to Join? (Joining Vs Multi-select) [duplicate]

piv4azn7 于 2023-05-16 发布在其他

关注(0)|答案(2)|浏览(194)

This question already has answers here:

Explicit vs implicit SQL joins (12 answers)
Closed 4 days ago.

Which of the below SQL queries is more performant, and why?

SELECT <columns>
FROM Dealer, DealerContact
WHERE Dealer.ID = DealerContact.DealerID

SELECT <columns>
FROM Dealer d
JOIN DealerContact dc on d.ID = dc.DealerID

sql-server

来源：https://stackoverflow.com/questions/76228413/to-join-or-not-to-join-joining-vs-multi-select

2条答案

按热度按时间

z9smfwbn1#

As far as I know, it's basically the same. Because the DBMS transforms all queries to improve their speed. The execution of the result would be the same.

赞(0）回复(0）举报 2023-05-16

py49o6xq2#

By default FROM Dealer, DealerContact will do a CROSS JOIN that is exponentialy performance consuming. When you don't need to do a CROSS JOIN , don't do it.

It will be better for both performance and code quality to use [INNER] JOIN in your case.

You could have a look at Microsoft documentation for further information.

赞(0）回复(0）举报 2023-05-16

我来回答

SQL Server To Join or Not to Join? (Joining Vs Multi-select) [duplicate]

2条答案

相关问题

热门标签

最新问答