optimization goal

optimization goal determines which optimization goal SAP ASE uses.

Summary Information

Default value

allrows_mix

Range of values

allrows_oltp, allrows_dss

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Query Tuning

Optimization goals are a convenient way to match user query demands with the best optimization techniques, ensuring optimal use of the optimizer’s time and resources. SAP ASE allows users to configure for two optimization goals, which you can specify at three tiers: server level, session level, and query level.

The server-level optimization goal is overridden at the session level, which is overridden at the query level.

These optimization goals allow you to choose an optimization strategy that best fits your query environment: