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