Smart Re-index Def: Smart re-index keeps the database available unlike normal re-index and the type of re-index(rebuild or re-organization) will be decided based on the fragmentation percentage. To set up smart reindex, we need to check the fragmentation level of the database and decide whether it should be index rebuild or reorganizing. If fragmentation percentage <30 then reorganize else rebuild After the reindex is performed, we update statistics for that database. Here's the git link for smart re-index Smar reindex code Above mentioned is one of the ways to configure smart re-index. A job can be scheduled to run the above code and reports can also be configured to check the fragmentation percentage.