Query Processing Based on SQL Anywhere 12.0.1 Architecture
We present an overview of SQL Anywhere’s advanced query processing and query optimization methodologies. This white paper describes how SQL Anywhere processes and transforms statements as they pass through the phases of query processing, including:
- SQL query
- Query rewrite
- Query optimization process
- Detailed access plan creation
- Plan execution
- SQL query result
This paper also describes the assumptions that underlie optimization and the design of the SQL Anywhere query optimizer, and discusses selectivity and cost estimation.
Click here to view the complete document (PDF).