Rebuilding Indexes or Updating Statistics, which do you do first?
Why?
Are there differences?
Rebuilding an index will update statistics with the equivalent of a full scan - doesn't matter whether you use DBCC DBREINDEX or ALTER INDEX...REBUILD, the effect is the same. It can do this because it sees a complete picture of the index while it’s doing the rebuild.
Reorganizing an index (using the old DBCC INDEXDEFRAG, or the new ALTER INDEX...REORGANIZE) will NOT update statistics at all, because it only sees a few pages of the index at a time.
So, which is the correct sequence?
