Oracle Hints

Hints for Optimization Approaches and Goals

• ALL_ROWS
• FIRST_ROWS(n)
• RULE

Hints for Access Paths

• FULL
• CLUSTER
• HASH
• INDEX
• NO_INDEX
• INDEX_ASC
• INDEX_COMBINE
• INDEX_JOIN
• INDEX_DESC
• INDEX_FFS
• NO_INDEX_FFS
• INDEX_SS
• INDEX_SS_ASC
• INDEX_SS_DESC
• NO_INDEX_SS

Hints for Query Transformations

• NO_QUERY_TRANSFORMATION
• USE_CONCAT
• NO_EXPAND
• REWRITE
• NO_REWRITE
• MERGE
• NO_MERGE
• STAR_TRANSFORMATION
• NO_STAR_TRANSFORMATION
• FACT
• NO_FACT
• UNNEST
• NO_UNNEST

Hints for Join Orders

• LEADING
• ORDERED

Hints for Join Operations

• USE_NL
• NO_USE_NL
• USE_NL_WITH_INDEX
• USE_MERGE
• NO_USE_MERGE
• USE_HASH
• NO_USE_HASH

Hints for Parallel Execution

• PARALLEL
• NO_PARALLEL
• PQ_DISTRIBUTE
• PARALLEL_INDEX
• NO_PARALLEL_INDEX

Additional Hints

• APPEND
• NOAPPEND
• CACHE
• NOCACHE
• PUSH_PRED
• NO_PUSH_PRED
• PUSH_SUBQ
• NO_PUSH_SUBQ
• QB_NAME
• CURSOR_SHARING_EXACT
• DRIVING_SITE
• DYNAMIC_SAMPLING
• SPREAD_MIN_ANALYSIS

http://www.oradev.com/hints.jsp