Here is a comprehensive list of all documented 11g hints. The 11g hints are organized by area:
Optimization Goals and Approaches (2)
|
Access Path Hints (17)
|
Other (20)
|
Join Operation (7)
|
ALL_ROWS
FIRST_ROWS
|
CLUSTER
FULL
HASH
INDEX
NO_INDEX
INDEX_ASC
INDEX_DESC
INDEX_COMBINE
INDEX_JOIN
INDEX_FFS
INDEX_SS
INDEX_SS_ASC
INDEX_SS_DESC
NATIVE_FULL_OUTER_JOIN
NO_NATIVE_FULL_OUTER_JOIN
NO_INDEX_FFS
NO_INDEX_SS
|
APPEND
NOAPPEND
CACHE
NOCACHE
CURSOR_SHARING_EXACT
DRIVING_SITE
DYNAMIC_SAMPLING
MODEL_MIN_ANALYSIS
MONITOR
NO_MONITOR
OPT_PARAM
PUSH_PRED
NO_PUSH_PRED
PUSH_SUBQ
NO_PUSH_SUBQ
PX_JOIN_FILTER
NO_PX_JOIN_FILTER
QB_NAME
RESULT_CACHE
NO_RESULT_CACHE
|
USE_HASH
NO_USE_HASH
USE_MERGE
NO_USE_MERGE
USE_NL
USE_NL_WITH_INDEX
NO_USE_NL
|
Join Order (2)
|
Query Transformation (13)
|
XML (2)
|
Parallel Execution (5)
|
ORDERED
LEADING
|
FACT
NO_FACT
MERGE
NO_MERGE
NO_EXPAND
USE_CONCAT
REWRITE
NO_REWRITE
NOREWRITE*
UNNEST
NO_UNNEST
STAR_TRANSFORMATION
NO_STAR_TRANSFORMATION
NO_QUERY_TRANSFORMATION
|
NO_XMLINDEX_REWRITE
NO_XML_QUERY_REWRITE
|
PARALLEL
NOPARALLEL*
NO_PARALLEL
PARALLEL_INDEX
NO_PARALLEL_INDEX
NOPARALLEL_INDEX*
PQ_DISTRIBUTE
|
No comments:
Post a Comment