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. It is set to 10 percent by default. However, 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
