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 and CREATE INDEX.
  • Back up and restore the database with gbak.

Topics

Advance To: