- Subquery: SELECT clause, correlation
- Join (cross/left/right/inner/full): FROM clause, no correlation
- Cross apply: FROM clause, correlation
The "cross apply" combines the best features of the subquery and join, but is performance-wise not always the best choice.
No comments:
Post a Comment