When joining with Persisted Computed Column I see performance degradation. For testing purpose I created another column in the table with same value that is in the Computed Column and the result comes very fast when I join against this new column. In the
Execution Plan I see the Number Of execution is same as the number of records being returned when I am joining against this Computed Column which is very high.
The expression for Computed Column is :
What is the reason behind this performance degradation ?