15.1.3 Relationships among threads used by the adbgetcst command

The adbgetcst command uses processing real threads in the following processing:

1. Retrieving table data (collecting cost information)

   One or more processing real threads are used.

2. Outputting the progress of command processing

   One processing real thread is used.

Steps 1 and 2 are performed at the same time.

The following figure shows the processing of the adbgetcst command using processing real threads. The preceding numbers correspond to the numbers in the figure.

Figure 15‒3: Processing of the adbgetcst command using processing real threads

The number of processing real threads used by the adbgetcst command for each step is automatically calculated from the number of processing real threads to be used by the adbgetcst command. For details about the number of processing real threads used by the adbgetcst command, see the description of the adb_getcst_rthd_num cost information collection option in (2) Explanation of specification format in 15.2.2 Format of the cost-information collection option.

To Page Top