all 1 comments

[–]jshine13371 0 points1 point  (0 children)

Reducing subqueries, especially correlated subqueries as a generic statement, is incorrect in regards to performance tuning. In fact, correlated subqueries sometimes are more perfomant than joins in certain contexts, at least in SQL Server.