parallel_min_scan_time_threshold is used in the Auto DOP strategy to calculate the degree of parallelism (DOP). This variable specifies the minimum evaluation period for the parallel scan of base tables. When the execution duration of the base table scan evaluation exceeds the specified value, parallel scan is enabled, and an appropriate DOP value is calculated based on the specified value.
Note
This variable was introduced in OceanBase Database V4.2.0.
| Attribute | Description |
|---|---|
| Type | UINT |
| Default value | 1000 |
| Value range | [10, 9223372036854775807], in milliseconds |
| Effective scope |
|
Examples
set parallel_min_scan_time_threshold = 100;
set global parallel_min_scan_time_threshold = 100;