Administration: Rebuild database indexes automatically
To rebuild indexes automatically, you enable the database maintenance option in Sitefinity:
- Navigate to Administration » Settings » Advanced » System.
- Select the RequireMaintenance checkbox.
- Restart your site.
As a result, you enabled the execution of performance optimization procedures for Microsoft SQL server, including the rebuilding of indexes.
IMPORTANT: This is a blocking operation during which you cannot work in Sitefinity CMS backend. You need to wait until the procedure is complete to resume work in the backend. The frontend is fully functional, though.