• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • Last Modified:

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 ?
0
Philip van Gass
Asked:
Philip van Gass
1 Solution
 
PortletPaulCommented:
Rebuilding indexes updates index statistics, not column statistics, so the process being followed isn't  redundant.
1
 
Vitor MontalvãoMSSQL 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
 
Philip van GassAuthor Commented:
I have reviewed this topic and it looks like Vitor is right.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now