showplan messages for parallel queries

showplan reports information about parallel execution, showing which query steps are executed in parallel.

showplan reports information about parallel execution, explicitly stating which query steps are executed in parallel.

Table 5-2: showplan messages for parallel queries

Message

Explanation

Executed in parallel by coordinating process and N worker processes.

Indicates that a query is run in parallel, and shows the number of worker processes used.

Executed in parallel by N worker processes.

Indicates the number of worker processes used for a query step.

Executed in parallel with a N-way hash scan.

Executed in parallel with a N-way partition scan.

Indicates the number of worker processes and the type of scan, hash-based of partition-based, for a query step.

Parallel work table merge. Parallel network buffer merge. Parallel result buffer merge.

Indicates the way in which the results of parallel scans were merged.

Parallel data merge using N worker processes.

Indicates that a merge join used a parallel data merge, and the number of worker processes used.

Serial data merge.

Indicates that the merge join used a serial data merge.

AN ADJUSTED QUERY PLAN WILL BE USED FOR STATEMENT N BECAUSE NOT ENOUGH WORKER PROCESSES ARE AVAILABLE AT THIS TIME. ADJUSTED QUERY PLAN:

Indicates that a run-time adjustment to the number of worker processes was required.