SAP ASE version 16.0 adds query performance improvements.
- Using dynamic instead of static thread assignments. Dynamic thread assignment
allows SAP ASE to execute parallel query plans faster and with fewer resources.
SAP ASE applies dynamic thread assignment to parallel lava query plans that are
generated for select queries.
- Improving the performance for queries run on tables with compressed data,
including removing columns required only by the search argument from the
substitution list.
- Improves the performance on certain parallel queries that include
SORT operators.
- Implements performance improvements and a reduction in resource usage for
certain parallel query plans involving HASH JOIN
operators.