Dynamic Thread Assignment

SAP ASE uses dynamic and static thread assignments.

Dynamic thread assignment allows SAP ASE to execute parallel query plans faster and with fewer resources than using static threads. SAP ASE applies dynamic thread assignment to parallel lava query plans that are generated for select queries. However, these commands use static thread assignment:
Dynamic thread assignment improves performance by:

Dynamic thread assignment is enabled when you configure SAP ASE for parallelism with the number of worker processes and max parallel degree parameters. See System Administration Guide, Volume 1 > Setting Configuration Parameters.