

Hint

hint
    : '/*+' hintStatements+=hintStatement (','? hintStatements+=hintStatement)* '*/'
    ;

hintStatement
    : hintName=identifier
    | hintName=identifier '(' parameters+=primaryExpression (',' parameters+=primaryExpression)* ')'
    ;

• HINT

SELECT /*+ HINT(t) */ *
  FROM t

• BROADCASTJOIN

SELECT /*+ BROADCASTJOIN(b) */ *
  FROM T1 a JOIN T2 b ON a.key = b.key

• MAPJOIN

SELECT /*+ MAPJOIN(b) */ *
  FROM T1 a JOIN T2 b ON a.key = b.key

• STREAMTABLE

SELECT /*+ STREAMTABLE(b) */ *
 FROM T1 a JOIN T2 b ON a.key = b.key

• INDEX

SELECT /*+ INDEX(t, ix_job_name) */ * 
  FROM t

• COALESCE

SELECT /*+ COALESCE(200) */ *
  FROM t

• REPARTITION

SELECT /*+ REPARTITION(200) */ *
  FROM t

Reference