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.
allrows_oltp – the most useful goal for purely OLTP queries.
allrows_dss – the most useful goal for operational DSS queries of medium-to-high complexity.