EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Rebuild Indexes


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 | iconRecomputeIndices Rebuild Database Indexes... main menu item, or right-click a table in the DB Explorer tree and select the Table Services | iconRecomputeIndices Rebuild All Indexes of Database context menu item.

 

menuRebuildIndexes

 

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.

 

 


See also:

Start/Stop Database

Indices

Using templates