Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Wednesday, February 20, 2013

11g hint list


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
RULE
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