ASA SQL User's Guide
Monitoring and Improving Performance
Using keys to improve query performance
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.