Database Maintenance Rebuild Indexes Overview

You can use this feature to run the Rebuild Indexes command. An index is a database structure created on a table to speed up data retrieval. (For example, searching an indexed column is often much faster than searching a non-indexed column.) SMS uses many indexes to improve database performance. This command creates indexes on database columns that are at least 50% unique, drops indexes on columns that are less than 50% unique, and rebuilds all existing indexes that meet the criteria.

Default    Runs on Sunday.

Related Topics

Topic Link

Schedule a Database Maintenance Task

Topic Link

Maintaining a Site Database Overview