Skip to main content
Skip table of contents

Configuring Options

Options can be configured in an OPTION clause, with the SET statement, and using the setDefaultOptionValue procedure. The table below shows how different values can be set:


(info) Default option values can be overridden explicitly by the option clause of a certain query or the SET statement for the current session

(info) Default option value for ALLOW_INDEX_RECOMMENDATIONALLOW_INDEX_CREATIONENABLE_EXPLAIN_LOG_OUTPUT, SKIP_STRUCTURE_CHECKING and WS_DATA_RETENTION_PATH changed via setDefaultOptionValue will affect the CData Virtuality Server behaviour immediately. All other default option values changed via setDefaultOptionValue will affect the CData Virtuality Server behaviour for sessions newly opened after the change. To the value of these options for the actual session, you can use the SET statement.

For more information on how to change an option's value using the appropriate method, please refer to the following sections of the Reference Guide:

  • Default Options for details on using the setDefaultOptionValue procedure;
  • SET Statement for information on how to change a value using the SET command;
  • OPTION Clause to know how to use it for changing option values.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.