We help IT Professionals succeed at work.

Rebuilding indexes and maintaining statistics

I have a client who has a maintenance plan that runs an update statistics task straight after rebuilding indexes. I have read recently that rebuilding indexes will automatically update the statistics tables, which if true, will make the task of updating statistics superfluous and unnecessary. Can you confirm that this is true ?
Watch Question

PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Rebuilding indexes updates index statistics, not column statistics, so the process being followed isn't  redundant.
IT Engineer
Distinguished Expert 2017
I can't agree with Paul. Rebuilding indexes will update statistics with FULL SCAN so by my point of view is redundant to update statistics after. Or even worse if the update statistics doesn't run with the FULL SCAN option.

Reorganizing indexes is a totally different story. After a REORG operation it's acceptable an UPDATE STATS operation.
Philip van GassDatabase Developer/Administrator


I have reviewed this topic and it looks like Vitor is right.