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 ?
Philip van GassDatabase Developer/AdministratorAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
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.
0
 
PortletPaulfreelancerCommented:
Rebuilding indexes updates index statistics, not column statistics, so the process being followed isn't  redundant.
1
 
Philip van GassDatabase Developer/AdministratorAuthor Commented:
I have reviewed this topic and it looks like Vitor is right.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.