After a large number of edits or a database compression, your indexes may become fragmented. This probably will not affect performance to any great extent in a geodatabase on an ArcSDE for SQL Server Express instance, but rebuilding indexes may give you a small performance boost. To rebuild indexes, follow the steps below.

1. In ArcCatalog, connect to the database server that contains the geodatabase with the indexes you want to rebuild.
2. Right-click the geodatabase for which you want to rebuild indexes.
3. Click Administration and click Geodatabase Maintenance.
4. Check Rebuild all indexes on the Geodatabase Maintenance dialog box.
5. Click OK.

Tip To rebuild indexes on a geodatabase, you must be an ArcSDE database server administrator or an administrator of the geodatabase for which you want to rebuild indexes.