prod-consumer overlap factor affects optimization. SAP ASE changes the group by algorithm, and you cannot use set statistics I/O with parallel plans.
|
Summary Information |
|
|---|---|
|
Default value |
20 |
|
Range of values |
|
|
Status |
dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |