Forum Discussion
Maintenance Plan Running forever -Sharepoint SQL Server 2016
Hello experts, we have maintenance plan which shrinks top 10 DATABASES based on the SIZE and free space available. It then checks database integrity, reorganizes the index, rebuilds the index and...
reorganizes the index, rebuilds the index and updates the statistics.
Jinal_P , index first reorg then rebuild; that's redundant and makes no sense; same with stats update after an index rebuild.
Throw away that maintenance plan and use SQL Server Index and Statistics Maintenance (hallengren.com)