Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Working with database objects


Working with indexes

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 can 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
Rebuilding indexes
Dropping indexes
Index information in the catalog