SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Run Update Statistics After Index Reorg?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ferrethouse
Constraint Violating Yak Guru

327 Posts

Posted - 02/12/2013 :  12:28:43  Show Profile  Reply with Quote
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
5071 Posts

Posted - 02/12/2013 :  12:39:43  Show Profile  Visit russell's Homepage  Reply with Quote
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
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1912 Posts

Posted - 02/12/2013 :  13:57:29  Show Profile  Visit jackv's Homepage  Reply with Quote
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

327 Posts

Posted - 02/12/2013 :  15:15:42  Show Profile  Reply with Quote
Sounds like a no to me :)

Thanks guys!
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1912 Posts

Posted - 02/14/2013 :  01:53:18  Show Profile  Visit jackv's Homepage  Reply with Quote
That's right, unless there are associated data loads

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000