Home Forums SQL Server 2008 SQL Server 2008 Administration Slow performance remains after query rebuild only gets resolved after updting statistics ? RE: Slow performance remains after query rebuild only gets resolved after updting statistics ?

  • GilaMonster (1/16/2013)


    Could well be that the stats that the query depends on are column stats, not index stats. REbuilding an index only updates the stats associated with that index (and invalidates any plans that use it)

    opc.three (1/16/2013)


    Column stats is the likely reason given the info.

    From the data I have and I've requested more an out of date statistic that is not part of the index he rebuild is the most likely cause of the problems. (I've came to the conclusion of this yesterday)