About Hints in SQL Statements

Hints are instructions that you add to a SQL statement that tell the data source query optimizer the most efficient way to run the statement.

Hints override the optimizer's processing plan, so you can use hints to improve performance by forcing the optimizer to use a more efficient plan. Hints are only supported for Oracle Database data sources.

You can add hints to a physical table or a join expression. When the object associated with the hint is queried, the Oracle Analytics query engine inserts the hint into the SQL statement.

For physical tables, SQL hints you specify for tables with the source type Table are supported, but SQL hints that you specify for tables with the source type Stored Procedure or Select Statement are ignored. For tables with the source type of Select Statement, you can provide the hint text as part of the SQL statement you enter in the DEFAULT field.