| Author |
 Topic  |
|
|
ferrethouse
Constraint Violating Yak Guru
305 Posts |
 Posted - 02/12/2013 : 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
USA
4968 Posts |
Posted - 02/12/2013 : 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.
|
Edited by - russell on 02/12/2013 12:39:59 |
 |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 02/12/2013 : 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
305 Posts |
Posted - 02/12/2013 : 15:15:42
|
Sounds like a no to me :)
Thanks guys! |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 02/14/2013 : 01:53:18
|
That's right, unless there are associated data loads
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
| |
Topic |
|
Run Update Statistics After Index Reorg?
