Performance: Conditions in WHERE clause vs. conditions in INNER JOIN? - Microsoft SQL Server

Performance: Conditions in WHERE clause vs. conditions in INNER JOIN? - Microsoft SQL Server

瀏覽:651
日期:2024-04-22
Performance: Conditions in WHERE clause vs. conditions in INNER JOIN?. Microsoft SQL Server Forums on Bytes. ... Logically I'd say that putting the conditions to the JOIN statement is faster as it reduces the amount of joined data whereas b) would join .....看更多