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.
| 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 BOLquote:
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.
|
 |
|
|
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 |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-02-12 : 15:15:42
|
| Sounds like a no to me :)Thanks guys! |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-14 : 01:53:18
|
| That's right, unless there are associated data loadsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Run Update Statistics After Index Reorg?