Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Run Update Statistics After Index Reorg?

Author  Topic 

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2013-02-12 : 12:28:43
If autoupdate statistics is true is there any point in running an update statistics job in an index reorg maintenance plan?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-02-12 : 12:39:43
From BOL
quote:
Operations such as rebuilding, defragmenting, or reorganizing an index do not change the distribution of data. Therefore, you do not need to update statistics after performing ALTER INDEX REBUILD, DBCC REINDEX, DBCC INDEXDEFRAG, or ALTER INDEX REORGANIZE operations. The query optimizer updates statistics when you rebuild an index on a table or view with ALTER INDEX REBUILD or DBCC DBREINDEX, however; this statistics update is a byproduct of re-creating the index. The query optimizer does not update statistics after DBCC INDEXDEFRAG or ALTER INDEX REORGANIZE operations.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-12 : 13:57:29
Even though Auto Update Statistics is turned on for the database , the decision to trigger the auto update statistics is based on : 1) the number of data modifications since the last statistics update , compared against the threshold
2)the threshold is based on the number of rows.

So, the decision as to whether leaving auto_update_statistics to execute based on criteria or issue an explicit UPDATE STATISTICS is based on the amount of data loaded.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

ferrethouse
Constraint Violating Yak Guru

352 Posts

Posted - 2013-02-12 : 15:15:42
Sounds like a no to me :)

Thanks guys!
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-14 : 01:53:18
That's right, unless there are associated data loads

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -