Improving Index Performance
From InterBase
Go Up to Working with Indexes
Indexes can become unbalanced after many changes to the database. When this happens, performance can be improved using one of the following methods:
- Rebuild the index with
ALTER INDEX
. - Recompute index selectivity with
SET STATISTICS
. - Delete and recreate the index with
DROP INDEX
andCREATE INDEX
. - Back up and restore the database with
gbak
.
Topics
- ALTER INDEX: Deactivating an Index
- SET STATISTICS: Recomputing Index Selectivity
- Dropping a User-defined Index