Contents Index Using foreign keys to improve query performance Sorting query results

ASA SQL User's Guide
  Monitoring and Improving Performance
    Using keys to improve query performance

Separate primary and foreign key indexes


Separate indexes are created automatically for primary and foreign keys. This arrangement allows Adaptive Server Anywhere to perform many operations more efficiently. This feature was introduced in version 7.0.


Contents Index Using foreign keys to improve query performance Sorting query results