Forum Discussion
Jinal_P
Feb 12, 2024Copper Contributor
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...
olafhelper
Feb 13, 2024Bronze Contributor
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)