Home Forums SQL Server 2005 Administering Will shrinking the DB improve time taken by index rebuild process ? RE: Will shrinking the DB improve time taken by index rebuild process ?

  • The main way to speed up index rebuilds is don't do them if they are not needed. Ola Hallengren http://ola.hallengren.com/ publishes an index rebuild routine used around the world that processes only those indexes that need work on them.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara