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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » 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.

When to use indexes
Deciding what indexes to create
Indexes on frequently-searched columns
Index hints
Using clustered indexes
Using SQL statements to cluster the index
Creating clustered indexes in Sybase Central
Reordering rows to match a clustered index
Create indexes
Validate indexes
Rebuild indexes
Drop indexes
Index information in the catalog