Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Query Optimizer » Query optimization and execution » How the optimizer works

 

Underlying assumptions

A number of assumptions underlie the design direction and philosophy of the SQL Anywhere query optimizer. You can improve the quality or performance of your own applications through an understanding of the optimizer's decisions. These assumptions provide a context in which you may understand the information contained in the remaining sections.


Minimal administration work
Optimize for first row or for entire result set
Optimize for mixed or OLAP workload
Statistics are present and correct
Indexes can be used to satisfy a predicate
Virtual memory is a scarce resource
The memory governor