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:
- Log in as a server administrator or geodatabase administrator, start ArcMap, then open the Catalog window.
Double-click the database server that contains the geodatabase with the indexes you want to rebuild.
This connects you to the database server.
- Right-click the geodatabase, click Administration, then click Geodatabase Maintenance.
- Check Rebuild all indexes on the Geodatabase Maintenance dialog box.
- Click OK.