16.1.4 Relationships among threads used by the adbidxrebuild command
The adbidxrebuild command uses processing real threads in the following processing:
-
Retrieving table data and rebuilding range indexes
One or more processing real threads are used.
-
Creating temporary work files
One or more processing real threads are used.
-
Sorting records of B-tree and text indexes
One or more processing real threads are used.
-
Rebuilding B-tree and text indexes
One or more processing real threads are used.
-
Outputting the progress of command processing
One processing real thread is used.
Steps 1 and 2 are performed at the same time. Then, step 3 and then step 4 are performed. Step 5 is always performed while steps 1 to 4 are in progress.
The following figure shows the processing of the adbidxrebuild command using processing real threads. The preceding numbers correspond to the numbers in the figure.
|
|
![[Figure]](GRAPHICS/F0000092.GIF)
The number of processing real threads used by the adbidxrebuild command for each step is automatically calculated from the number of processing real threads to be used by the adbidxrebuild command. For details about the number of processing real threads to be used by the adbidxrebuild command, see the description of the index rebuild option adb_idxrebuild_rthd_num in (2) Explanation of specification format in 16.2.2 Format of index rebuild options.