How to find out what is represented by the intermediate value used in SQL Server execution plan
user5965 Published in September 19, 2018, 11:26 am
I'm learning how to read the actual execution plan in SQL Server. I have noticed that SQL Server tends to represent intermediate value used in the physical query plan as e.g. expr1006, expr1007 etc. (i.e. expr followed by a number).
Here is a screenshot. Notice near the bottom, the expressions expr1006, expr1008, expr1009 listed in the section output list.
It it possible to find out what they really represent?