List of Available Hints in Oracle

A)Optimization Goals and Approaches Category
--------------------------------------------------------------
ALL_ROWS
FIRST_ROWS
RULE

B)Access Path Hints Category
----------------------------------------------------
CLUSTER
FULL
HASH
INDEX
NO_INDEX
INDEX_ASC
INDEX_DESC
INDEX_COMBINE
INDEX_JOIN
INDEX_FFS
INDEX_SS
INDEX_SS_ASC
INDEX_SS_DESC
NO_INDEX_FFS
NO_INDEX_SS

C)Join Order Hints Category
---------------------------------------------
ORDERED
LEADING

D)Join Operation Hints Category
---------------------------------------------
USE_HASH
NO_USE_HASH
USE_MERGE
NO_USE_MERGE
USE_NL Hint
USE_NL_WITH_INDEX
NO_USE_NL

E)Parallel Execution Hints Category
-------------------------------------------------------------------
PARALLEL
NO_PARALLEL
PARALLEL_INDEX
NO_PARALLEL_INDEX
PQ_DISTRIBUTE

F)Query Transformation Hints Category
-------------------------------------------------------------
FACT
NO_FACT
MERGE
NO_MERGE
NO_EXPAND
USE_CONCAT
REWRITE
NO_REWRITE
UNNEST
NO_UNNEST
STAR_TRANSFORMATION
NO_STAR_TRANSFORMATION
NO_QUERY_TRANSFORMATION

Other Hints Category
-----------------------------------------------------
APPEND
NOAPPEND
CACHE
NOCACHE
CURSOR_SHARING_EXACT
DRIVING_SITE
DYNAMIC_SAMPLING
PUSH_PRED
NO_PUSH_PRED
PUSH_SUBQ
NO_PUSH_SUBQ
PX_JOIN_FILTER
NO_PX_JOIN_FILTER
NO_XML_QUERY_REWRITE
QB_NAME
MODEL_MIN_ANALYSIS