Home Forums SQL Server 2008 SQL Server 2008 - General Covering index on persisted computed column being ignored RE: Covering index on persisted computed column being ignored

  • November 14, 2012 at 10:43 am

    #1559044

    I think SQL optimiser is second-guessing you because your computed column is equal to the 'real' one.

    See if you get the behaviour you expect when the column is defined as: col1Persisted AS col1*2 PERSISTED

    Cheers

    Gaz