SQL Hint

The SQL Hint property is used for the Oracle SQL Hint pattern. This string is placed after the SELECT word in the Select statement. This property can be used to insert any SQL string that makes sense after the SELECT in a Select statement, but it is provided specifically for Oracle SQL Hints.

Levels at Which You Can Set This

Database instance, report, and template

SQL Hint = /* FULL */
Select /* + FULL */ A1.STORE_NBR, 
max(A1.STORE_DESC) 
From LOOKUP_STORE A1 
Where A1.STORE_NBR = 1
Group by A1.STORE_NBR