MindOptimizer (10/14/2010)
GilaMonster (10/14/2010)
Since it's running after an index rebuild, you only need to update column statistics, not index statistics.Will it get benefit, if we go for first "update statistics" then for "index rebuild/reorganize" ?
No.
Either way (before or after) if the update stats does index stats as well as column stats it's wasting time as the rebuild indexes updates index stats.
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