Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Query Cache-Related Parameters

The following are parameters related to the query cache functionality that provides execution results cached for the same SELECT statement. The type and value range for each parameter are as follows:

Parameter Name

Type

Default Value

Min

Max

max_plan_cache_entries

int

1,000

 

 

max_filter_pred_cache_entries

in

1,000

   
max_plan_cache_entries

max_plan_cache_entries is a parameter used to configure the maximum number of query plans to be cached in the memory. If the max_plan_cache_entries parameter is configured to -1 or 0, generated query plans are not stored in the memory cache; if it is configured to an integer value equal to or greater than 1, a specified number of query plans are cached in the memory.

The following example shows how to cache up to 1,000 queries.

max_plan_cache_entries=1000

max_filter_pred_cache_entries

max_filter_pred_cache_entries is a parameter used to specify the maximum number of of filtered index expressions. The filtered index expressions are stored with them complied and can be immediately used in server. If it is not stored in cache, the process is required which filtered index expressions are fetched from database schema and interpreted.