SQL Anywhere 10.0.1
» SQL Anywhere Server - SQL Usage
» Monitoring and Improving Performance
» Performance improvement tips
» Use keys to improve query performance
Separate primary and foreign key indexes
Separate indexes are created automatically for primary and foreign keys. This arrangement allows SQL Anywhere to perform many operations more efficiently.