Contents Index Composite indexes Types of index

ASA SQL User's Guide
  Query Optimization and Execution
    Indexes

Other uses for indexes


Adaptive Server Anywhere uses indexes to achieve other performance benefits. Having an index allows Adaptive Server Anywhere to enforce column uniqueness, to reduce the number of rows and pages that must be locked, and to better estimate the selectivity of a predicate.


Contents Index Composite indexes Types of index