max resource granularity indicates the maximum percentage of the system’s resources a query can use.
|
Summary Information |
|
|---|---|
|
Default value |
10 |
|
Range of values |
1 – 100 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
max resource granularity is not enforced at execution time, but is only a guide for the query optimizer, and does not prevent the query processor from running queries in parallel. The query engine can avoid some memory-intensive strategies by using max resource granularity as a guide.