Runtime adjustment

If there are not enough worker processes available at runtime, the execution engine attempts to reduce the number of worker processes used by the exchange operators present in the plan.

It does so in two ways:

Adaptive Server supports serial recompilation for these type of queries:

Support for select into for ad-hoc and stored procedures will be available in a future release.