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 indicates the maximum percentage of the system’s resources a query can use. This parameter 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.
