CONCEPT: How RockSolid Selects the Appropriate Index Rebuild Method

RockSolid will either do Online (non-blocking) or Offline (blocking) database index maintenance depending on how you configure the database index maintenance window. For reference, the definitions of each of these modes is as follows:

  • Offline – Traditional database index Rebuild (ALTER INDEX with the REBUILD option)
  • Online – Either an online index rebuild, if configured and supported by SQL Server (see below), or a database index reorganize.

For more information on how to configure index maintenance see:Enabling RockSolid Automated Index Maintenance

For each index RockSolid will use a precedence hierarchy for determining the

appropriate rebuild method for each index, being:

  1. If an offline index rebuild window and offline rebuilds are allowed the REBUILD the index
  2. If an online index rebuild window, and online rebuilds are allowed and online rebuilds are supported then ONLINE REBUILD the index.
  3. If defrag is enable REOGRANISE the index
  4. Otherwise record fragmentation and update index statistics only (if configuration does not allow any rebuild to occur).


SQL Server Support for Index Maintenance Methods


  • Supported by all versions and editions


Online Rebuilds

  • Supported by SQL Server Enterprise Editions from version 2005 and above
  • Supported on table indexes (clustered) and non-clusetered index without large object types (text, varchar(max), xml etc)
  • Supported when page level locking is not disabled for a given index


Reorganise (defrag)

  • Supported by all versions and editions



Have more questions? Submit a request


Please sign in to leave a comment.