Perform a manual rebuild of fragmented indexes

Manually rebuild the indexes to reduce database fragmentation in real time. The index rebuild process may take several minutes to complete and may impact the system performance. Rebuild indexes during server null time when no scheduled tasks or user interaction is taking place if possible.
Prerequisites
  • Make sure you have the
    Configure Database Maintenance
     permission.
To perform a manual analysis of index fragmentation
  1. Select
    Tools > Options
    .
  2. Under
    Category
    on the left side of the dialog box, select
    Database Maintenance
    .
  3. In the
    Manual Database Maintenance
     section, click
    Rebuild Index
    .
    A message shows next to the button, indicating the rebuild process.
  4. Close the
    Options
    dialog box.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal