Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Performance issue with Join on Computed Column

Unanswered Performance issue with Join on Computed Column

  • Monday, January 21, 2013 5:57 PM
     
     
    Sign In to Vote
    0

    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 :

    [Id] 

    AS (([Code]+'_')+CONVERT([varchar](10),[MiddletierId],(0))) PERSISTED NOT NULL,

    What is the reason behind this performance degradation ?

    Thanks!!

     

All Replies