I'm going to reorganize indexes with > 10%.
Is there a need to update statistics after the re-org?
Understand that if it's a rebuild, SQL server will automatically update the stats.
My question is, does re-org need a update statistics? Is the old statistics still accurate after re-org?
In Micrsoft Note:
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.