Rebuilding indexes and maintaining statistics

Philip van Gass
Philip van Gass used Ask the Experts™
on
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 ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Commented:
Rebuilding indexes updates index statistics, not column statistics, so the process being followed isn't  redundant.
MSSQL Senior Engineer
Distinguished Expert 2017
Commented:
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

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today