chewychewy (3/19/2013)
Hi Guys,I'm going to reorganize indexes with > 10%.
Is there a need to update statistics after the re-org?
No need.
From the 2008 R2 article http://msdn.microsoft.com/en-us/library/ms190397(v=sql.105).aspx:
Do not update statistics after operations such as rebuilding, defragmenting, or reorganizing an index. These operations do not change the distribution of data and have no impact on statistics. Note, however, that the query optimizer updates statistics when you rebuild an index on a table or view by using ALTER INDEX REBUILD or DBCC DBREINDEX. This occurs as a byproduct of the internal implementation of these operations and is not done because statistics need to be updated. The query optimizer does not update statistics after defragmentation or reorganization operations because these operations do not drop and recreate the index.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato