TDV includes many configuration parameters that can be manipulated to optimize how the server processes the queries that you execute through TDV. With many of these optimizations, TDV does the work to detect how it can best process your SQL. 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 selecting Administration > Configuration from the main menu and navigating to the parameters under TDV Server > SQL Engine.

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.