max resource granularity

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.