QUESTION POSED ON: 24 January 2006 Is it necessary to update statistics after indexes are rebuilt?
>
EXPERT RESPONSE
No. When indexes are rebuilt (using DBCC DBREINDEX or the newer ALTER INDEX REBUILD syntax) statistics are automatically updated. However, this is not the case when reorganizing indexes (using DBCC INDEXDEFRAG or ALTER INDEX REORGANIZE). If you are doing an index reorganization rather than an index rebuild, you might find it useful to update the statistics after the process completes.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
