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);;
