Rebuilding indexes in a geodatabase on a database server

After a large number of edits or a database compress operation, your indexes may become fragmented. This probably will not affect performance to any great extent in a geodatabase on a database server (a SQL Server Express instance), but rebuilding indexes may give you a small performance boost. To rebuild indexes, follow these steps:

  1. Log in as a server administrator or geodatabase administrator, start ArcMap, then open the Catalog window.
  2. Double-click the database server that contains the geodatabase with the indexes you want to rebuild.

    This connects you to the database server.

  3. Right-click the geodatabase, click Administration, then click Geodatabase Maintenance.
  4. Check Rebuild all indexes on the Geodatabase Maintenance dialog box.
  5. Click OK.