Q1 CTE's vs Subquery

[tykim6]

As far as performance is concerned, is there any reason why you should use a CTE/join over a subquery that UNION ALL's the two tables? (aside from the fact that calculating the difference is easier)

[andrewhong5297]

you should pretty much always avoid UNION ALL when you can since it's really expensive.