Using Oracle SQL Optimizer Hints
Query performance can sometimes be improved by adding Oracle optimizer hints. If you decide a query hint is necessary, you can use TDV to add the hint to the query syntax; the hint is passed to the database for processing at runtime. The query must be against an Oracle database. The hint syntax must be valid for the version of Oracle that you are using.
No validation is done by TDV or Oracle on the hint syntax. TDV does not guarantee that the query hint will be pushed, because plan optimization may cause the hint to be dropped. Use the Show Execution Plan button to check whether the hint was pushed or not.
For more information about Oracle optimizer hints, see the Oracle Database Performance Tuning Guide.
To add an Oracle optimizer hint to a query retrieving data from an Oracle data source
1. Locate a view in your TDV project that accesses data from an Oracle data source.
2. Select the SQL tab.
3. Enter in the Oracle hint syntax immediately following the SELECT statement.
For example:
4. Save the view.
5. Execute the view to test that the query performs as expected.
