parallel_min_scan_time_threshold

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.

Examples

set parallel_min_scan_time_threshold = 100;

set global parallel_min_scan_time_threshold = 100;