You are looking at an older version of the documentation. The latest version is found here.
This option controls whether query plans for each executed SQL query are stored in the query logs or not. It can take one of the following values:
| Value | Description |
|---|
TRUE
| - Query plan is automatically generated at runtime for each executed SQL query and stored in the configuration database;
- XML representation of the query plan for SQL query can be retrieved using the
EXPLAIN command; - The
SYSLOG.getQueryLogPlan procedure returns a stored query plan for a specific entry in the SYSLOG.QueryLogs table; - Default value
|
FALSE
| - Query plan is automatically generated at runtime for each executed SQL query, but not stored in the configuration database;
- XML representation of the query plan for SQL query can be retrieved using the
EXPLAIN command; - The
SYSLOG.getQueryLogPlan procedure returns NULL for the queries executed after setting this value for the STORE_QUERY_PLANS option as there are no stored plans for them.
|
Example
SQL
CALL SYSADMIN.setDefaultOptionValue(' STORE_QUERY_PLANS', FALSE);;
