Updating index statistics sql
Quite a few facts ended up surprising the audience.
I thought I’d share a few and wanted to start with index rebuild.
REORGANIZE statement, does not update any statistics.
So depending on your maintenance jobs and scripts several scenarios can exist.
He is the author of three books, “High Performance SQL Server”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also coauthored other books including “SQL Server 2012 Internals”.
Benjamin has also been a speaker at many SQL Server conferences and events around the world including the PASS Summit, SQL Server Connections and SQLBits.
REBUILD statement, will update only index statistics with the equivalent of using WITH FULLSCAN.Notice the value of the auto_created column which tells if the statistics were automatically created by the query processor.