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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects

Retrieving information about materialized views Next Page

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