Improving Index Performance

From InterBase
Jump to: navigation, search

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: