Underlying assumptions of the optimizer

Several 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