Online Documentation for SQL Manager for InterBase/Firebird

Rebuild Database Indices

Rebuild Indexes Wizard allows you to recompute or rebuild indexes.

To improve index performance, one should consider recomputing or rebuilding database indexes.

Recomputing index selectivity is performed through SET STATISTICS. Index selectivity is a calculation, based on the number of distinct rows in a table, that is made by the optimizer when a table is accessed. It is cached in memory, where the optimizer can access it to calculate the optimal retrieval plan for a given query.

Rebuilding an index consists in making it inactive, then active with sequential calls to ALTER INDEX. Deactivating an index is exactly like dropping it, except that the index definition remains in the database. Activating an index creates a new index structure.

To run the wizard, select the Services | Rebuild Database Indexes... main menu item, or right-click a table in the DB Explorer tree and select the Table Services | Rebuild All Indexes of Database context menu item.

• Selecting database and execution mode
• Selecting action for indexes
• Selecting indexes
• Recomputing/rebuilding indexes