parallel_min_scan_time_threshold

parallel_min_scan_time_threshold is used in the Auto DOP policy 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 base table scan evaluation exceeds the specified value, parallel scan is enabled, and an appropriate DOP value is calculated based on the specified value.

Sample code

set parallel_min_scan_time_threshold = 100;

set global parallel_min_scan_time_threshold = 100;