How to find Expr#### in Execution Plan
I found this to be the more detailed answer : https://stackoverflow.com/a/49841492/235041 The value is under "Defined Values" on the property sheet
In the Execution Plan
window of SSMS
, right click on the operation that first calculates the expression and select Properties
.
You will see the expression definition in the pane to the right.
Alternatively, you can browse the XML
plan and search for the entries like that:
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1018" />
<ScalarOperator ScalarString="col1 + col2">
</ScalarOperator>
</DefinedValue>
…
</DefinedValues>