Query Performance Improvements

SAP ASE version 16.0 introduces improvements to queries.

• Dynamic Thread Assignment
  SAP ASE version 16.0 and later uses dynamic instead of static thread assignments.
• SORT Operator Performance Improvement
  SAP ASE version 16.0 and later improves the performance on certain parallel queries that include SORT operators.
• Hash Join Operator Performance Improvement
  SAP ASE versions 16.0 and later implement performance improvements and a reduction in resource usage for certain parallel query plans involving HASH JOIN operators.