ASA SQL User's Guide
Working with Database Objects
Performance is an important consideration when designing and creating your database. Indexes can dramatically improve the performance of statements that search for a specific row or a specific subset of the rows. On the other hand, indexes take up additional disk space and may slow inserts, updates, and deletes.
Choosing a set of indexes
When to use indexes
Use indexes for frequently-searched columns
Using clustered indexes
Creating indexes
Validating indexes
Dropping indexes
Index Consultant overview
Starting the Index Consultant
Stopping the Index Consultant
Understanding the Index Consultant
Indexes in the system tables