TDV Query Engine Options
This topic describes the TDV SQL query engine hints (options) used to suggest how the execution plan might be optimized.
Execution of SQL views, procedures, and transactions created with TDV-defined resources follows an optimized execution plan. The execution plan is generated dynamically based on how the SQL is written, what and how native resources are being used, TDV configuration settings, the presence of data-source-specific statistical data, and the presence of TDV SQL query engine options.
The following apply to this topic:
• Keywords (option names and values) are not case-sensitive. For example, "TRUE" and "true" are equivalent. However, in this documentation, they are presented in all-uppercase.
• If a TRUE/FALSE option is specified without a value, it is implicitly set to TRUE. For example, the syntax definition CASE_SENSITIVE[={"TRUE"|"FALSE"}] means that you can specify CASE_SENSITIVE (with no value) or CASE_SENSITIVE="TRUE" to set it to TRUE, or specify CASE_SENSITIVE="FALSE" to set it to FALSE.
Query engine options let the developer influence the generation of the execution plan by overriding, for specific SQL statements and keywords, TDV configuration settings. The configuration settings can be found in Studio by navigating to the parameters under TDV Server > SQL Engine.