parallel_min_scan_time_threshold is a parameter used to calculate the degree of parallelism in the Auto DOP strategy. It sets the minimum estimated execution time for parallel processing of base table scans. When the estimated execution time for a base table scan exceeds this threshold, parallelism is enabled, and an appropriate degree of parallelism is calculated using this value.
Note
This variable is available starting with V4.2.0.
Attribute |
Description |
|---|---|
| Parameter type | uint |
| Default Value | 1000 |
| Value range | [ 10,9223372036854775807 ] Unit: ms |
| Effective Scope |
|
Example
set parallel_min_scan_time_threshold = 100;
set global parallel_min_scan_time_threshold = 100;