このオプションは、実行された各SQL クエリのクエリプランをクエリログに格納するかどうかを制御します。以下のいずれかの値を取ります:

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

CALL SYSADMIN.setDefaultOptionValue(' STORE_QUERY_PLANS', FALSE);;