This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:optimization:config:thresholds [2012/02/13 22:26] doc |
admin:optimization:config:thresholds [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 63: | Line 63: | ||
| The Hashed Data Cache Threshold determines how much data should be available to a process for temporary caching of data to improve table join performance. The Hashed Data Cache will cache small tables or blocks of data that will be accessed repeatedly, but will not exceed the Hashed Data Cache Threshold. | The Hashed Data Cache Threshold determines how much data should be available to a process for temporary caching of data to improve table join performance. The Hashed Data Cache will cache small tables or blocks of data that will be accessed repeatedly, but will not exceed the Hashed Data Cache Threshold. | ||
| - | The default Hashed Data Cache Threshold is 32MB, meaning that each process may use up to 32MB of memory to temporarily cache data in a query. | + | The default Hashed Data Cache Threshold is 32MB, meaning that each query may use up to 32MB of memory to temporarily cache data. |
| The Hashed Data Cache Threshold is changed using the HDC_THRESHOLD option of the SELECT statement. The value used in this option is the number of megabytes of memory that should be allowed. | The Hashed Data Cache Threshold is changed using the HDC_THRESHOLD option of the SELECT statement. The value used in this option is the number of megabytes of memory that should be allowed. | ||