Summary information |
|
|---|---|
Default value |
20 |
Range of values |
|
Status |
dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
|
‘prod-consumer overlap factor’ is a configuration parameter that affects optimization. Adaptive Server changes the group by algorithm, and you cannot use set statistics I/O with parallel plans.
1> sp_configure 'prod-consumer overlap factor' 2> go
