:::: MENU ::::

Satistics updation with Reindex

DBA Interview questions, dbDigger, Indexes

Satistics updation with Reindex

Question: Does SQL Server update statistics with Reindex on a table in SQL Server 2005?

Answer: Yes, with full table scan details

Explanation: Whenever an index is rebuilt the stats on the table is updated with the details of a full table scan.

Ref: Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics

Note: The Question of day is taken from SQLServercentral.com. I want to compile selected QOD.

Consult us to explore the Databases. Contact us