Indexes can become less effi cient after a large number of changes are made to a database. After a large number of edits to a geodatabase and after compressing a geodatabase, you should rebuild the database indexes so the SQL Server optimizer can respond to queries in the most efficient manner possible.