Mixed, OLAP

Mixed

Can only be set for PUBLIC. You must have the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

The optimization_workload option controls whether SQL Anywhere optimizes queries for a workload that is a mix of updates and reads or that is predominantly read-only.

If the option is set to Mixed (the default), SQL Anywhere chooses query optimization algorithms appropriate for a workload that is a mixture of short inserts, updates, and deletes and longer running read-only queries.

If the option is set to OLAP, SQL Anywhere chooses algorithms appropriate for a workload that consists for the most part of long-running queries, combined with batch updates. In particular, the optimizer may choose to use the Clustered Hash Group By query execution algorithm.

When the option is set to OLAP, the Clustered Hash Group By algorithm is enabled. If the option is set to Mixed (the default), it is disabled.

You can override any temporary or PUBLIC settings for this option within individual INSERT, UPDATE, DELETE, SELECT, UNION, EXCEPT, and INTERSECT statements by including an OPTION clause in the statement.

• optimization_level option
• optimization_workload connection property