ASA SQL User's Guide
Query Optimization and Execution
The following is an explanation of the algorithms Adaptive Server Anywhere uses to compute queries.
Accessing tables
Join algorithms
Duplicate elimination
Grouping
Sorting and unions
Miscellaneous