'Optimization goals' are a central concept of the new query processing engine in ASE 15, as they control the possible query plans that the query optimizer may consider for a query.  Therefore, the choice of optimization goal can make a major difference for the performance of a query.

The scope and semantics of specifying session-level settings for optimization goals (as well as for the underlying 'optimization criteria') have undergone some changes in ASE versions 15.0.2, 15.0.2 ESD#1 and 15.0.2 ESD#2, as described in this document.

Click here to download whitepaper.