Improving Index Performance

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

• ALTER INDEX: Deactivating an Index
• SET STATISTICS: Recomputing Index Selectivity
• Dropping a User-defined Index