If we use BETWEEN what will be the impact of performance. Let us watch Performance: Between and Other Operators.
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.