• The automatically created stats are ones which the Query Optimiser requests be created to help it generate optimal execution plans. Keeping them updated is as important or more important than updating stats on indexes. They at least get updated when the index is rebuilt.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass