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:

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.