Setting Default Query Options
Query hints are options that you can include to optimize your SQL statement for the TDV query engine. You can specify any of the options that are documented in “TDV Query Engine Options” in the TDV Reference Guide.
Options specified in a query override any defaults set using the configuration parameter values.
To specify global query hints
1. Select Administration > Configuration.
2. In the Configuration window, navigate to Default SQL Options.
3. Click the green plus button.
4. Type an option or hint type value for the Key. For example, INDEX.
5. Type a Key Value. For example, employees emp_dept_ix.
6. Click OK, to save the changes and exit the Configuration screen.