Home Forums SQL Server 2008 SQL Server 2008 - General Odd behaviour from computed columns in a left outer join RE: Odd behaviour from computed columns in a left outer join

  • August 30, 2012 at 1:37 pm

    #1532103

    Kenneth.Fisher (8/30/2012)

    Just a guess but you might consider looking at your indexes. You probably have an index that covers CE.ID, CA.CustomerID and CA.PostalCode but doesn't include CA.EnglishAddressLine1.

    I did a quick test and I was able to include a computed column in an index. Both as part of the index and as an included column.

    Unfortunately it's not the case here. The function is referencing columns from other tables.

    Alex Suprun