Oracle Hint 所有名称

APPEND
NOAPPEND
NO_MONITORING
NO_SQL_TUNE
DEREF_NO_REWRITE
NESTED_TABLE_GET_REFS
PRESERVE_OID
NESTED_TABLE_SET_SETID
NESTED_TABLE_FAST_INSERT
INLINE_XMLTYPE_NT
REF_CASCADE_CURSOR
NO_REF_CASCADE
FORCE_XML_QUERY_REWRITE
NO_XML_QUERY_REWRITE
IGNORE_WHERE_CLAUSE
OPAQUE_TRANSFORM
OPAQUE_XCANONICAL
SYS_DL_CURSOR
SQLLDR
DML_UPDATE
VECTOR_READ
VECTOR_READ_TRACE
EXPR_CORR_CHECK
STREAMS
MERGE_CONST_ON
USE_WEAK_NAME_RESL
NO_QUERY_TRANSFORMATION
OPTIMIZER_FEATURES_ENABLE
DB_VERSION
FBTSCAN
GATHER_PLAN_STATISTICS
IGNORE_OPTIM_EMBEDDED_HINTS
TABLE_STATS
INDEX_STATS
COLUMN_STATS
RULE
CHOOSE
FIRST_ROWS
ALL_ROWS
ORDERED
ORDERED_PREDICATES
DOMAIN_INDEX_SORT
DOMAIN_INDEX_NO_SORT
SKIP_EXT_OPTIMIZER
CPU_COSTING
NO_CPU_COSTING
OLD_PUSH_PRED
PUSH_PRED
NO_PUSH_PRED
PULL_PRED
NO_PULL_PRED
ELIMINATE_OBY
NO_ELIMINATE_OBY
ELIMINATE_JOIN
NO_ELIMINATE_JOIN
OUTER_JOIN_TO_INNER
NO_OUTER_JOIN_TO_INNER
PUSH_SUBQ
NO_PUSH_SUBQ
GBY_PUSHDOWN
NO_GBY_PUSHDOWN
USE_CONCAT
NO_EXPAND
SEMIJOIN_DRIVER
ANTIJOIN
MERGE_AJ
HASH_AJ
NL_AJ
SEMIJOIN
NO_SEMIJOIN
MERGE_SJ
HASH_SJ
NL_SJ
STAR
REMOTE_MAPPED
STAR_TRANSFORMATION
NO_STAR_TRANSFORMATION
REWRITE
NO_REWRITE
NO_MULTIMV_REWRITE
NO_BASETABLE_MULTIMV_REWRITE
REWRITE_OR_ERROR
BYPASS_UJVC
UNNEST
NO_UNNEST
LOCAL_INDEXES
HWM_BROKERED
OVERFLOW_NOMOVE
SYS_PARALLEL_TXN
SYS_RID_ORDER
BYPASS_RECURSIVE_CHECK
MATERIALIZE
INLINE
CONNECT_BY_COST_BASED
NO_CONNECT_BY_COST_BASED
CONNECT_BY_FILTERING
NO_CONNECT_BY_FILTERING
SET_TO_JOIN
NO_SET_TO_JOIN
PIV_SSF
TIV_SSF
PIV_GB
TIV_GB
CUBE_GB
SAVE_AS_INTERVALS
RESTORE_AS_INTERVALS
BITMAP
SCN_ASCENDING
NO_QKN_BUFF
BUFFER
NO_BUFFER
CURSOR_SHARING_EXACT
MV_MERGE
EXPAND_GSET_TO_UNION
NO_EXPAND_GSET_TO_UNION
MODEL_MIN_ANALYSIS
MODEL_NO_ANALYSIS
MODEL_DYNAMIC_SUBQUERY
MODEL_COMPILE_SUBQUERY
MODEL_PUSH_REF
NO_MODEL_PUSH_REF
MODEL_DONTVERIFY_UNIQUENESS
NO_PRUNE_GSETS
USE_TTT_FOR_GSETS
USE_HASH_AGGREGATION
NO_USE_HASH_AGGREGATION
GBY_CONC_ROLLUP
NO_STATS_GSETS
NO_ORDER_ROLLUPS
QB_NAME
DYNAMIC_SAMPLING
CARDINALITY
LEADING
MERGE
NO_MERGE
FULL
SHARED
NOPARALLEL
NO_PARALLEL
CACHE_CB
CACHE
NOCACHE
CACHE_TEMP_TABLE
DRIVING_SITE
QUEUE_CURR
QUEUE_ROWP
USE_MERGE_CARTESIAN
USE_MERGE
NO_USE_MERGE
USE_HASH
NO_USE_HASH
USE_NL
USE_NL_WITH_INDEX
NO_USE_NL
USE_ANTI
USE_SEMI
PQ_DISTRIBUTE
SUBQUERY_PRUNING
NO_SUBQUERY_PRUNING
LIKE_EXPAND
OR_EXPAND
PQ_MAP
PQ_NOMAP
AND_EQUAL
INDEX_ASC
INDEX
INDEX_DESC
NO_INDEX
INDEX_FFS
NO_INDEX_FFS
INDEX_SS
INDEX_SS_ASC
INDEX_SS_DESC
NO_INDEX_SS
INDEX_COMBINE
BITMAP_TREE
INDEX_JOIN
INDEX_RRS
HASH
PARALLEL_INDEX
NO_PARALLEL_INDEX
SWAP_JOIN_INPUTS
NO_SWAP_JOIN_INPUTS
FACT
NO_FACT
NO_ACCESS
DYNAMIC_SAMPLING_EST_CDN
CLUSTER
ROWID
OPT_ESTIMATE
X_DYN_PRUNE
RESTRICT_ALL_REF_CONS
SKIP_UNQ_UNUSABLE_IDX
TRACING
NO_PARTIAL_COMMIT
INCLUDE_VERSION
NO_CARTESIAN
PX_JOIN_FILTER
NO_PX_JOIN_FILTER
PRECOMPUTE_SUBQUERY
RBO_OUTLINE
OUTLINE
OUTLINE_LEAF
OPT_PARAM
DBMS_STATS
DOMAIN_INDEX_FILTER
NO_DOMAIN_INDEX_FILTER
RESULT_CACHE
NO_RESULT_CACHE
NO_XML_DML_REWRITE
XML_DML_RWT_STMT
PLACE_GROUP_BY
NO_PLACE_GROUP_BY
INDEX_RS_ASC
INDEX_RS_DESC
NO_LOAD
NUM_INDEX_KEYS
CHECK_ACL_REWRITE
NO_CHECK_ACL_REWRITE
CONNECT_BY_COMBINE_SW
NO_CONNECT_BY_COMBINE_SW
XMLINDEX_REWRITE
NO_XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT
NO_XMLINDEX_REWRITE_IN_SELECT
NATIVE_FULL_OUTER_JOIN
NO_NATIVE_FULL_OUTER_JOIN
COST_XML_QUERY_REWRITE
NO_COST_XML_QUERY_REWRITE
NLJ_PREFETCH
NO_NLJ_PREFETCH
NLJ_BATCHING
NO_NLJ_BATCHING
MONITOR
NO_MONITOR
USE_INVISIBLE_INDEXES
NO_USE_INVISIBLE_INDEXES
BIND_AWARE
NO_BIND_AWARE
IGNORE_ROW_ON_DUPKEY_INDEX
CHANGE_DUPKEY_ERROR_INDEX
RETRY_ON_ROW_CHANGE
COALESCE_SQ
NO_COALESCE_SQ
TRANSFORM_DISTINCT_AGG
NO_TRANSFORM_DISTINCT_AGG
CONNECT_BY_ELIM_DUPS
NO_CONNECT_BY_ELIM_DUPS
DST_UPGRADE_INSERT_CONV
NO_DST_UPGRADE_INSERT_CONV
STATEMENT_QUEUING
NO_STATEMENT_QUEUING
CONNECT_BY_CB_WHR_ONLY
NO_CONNECT_BY_CB_WHR_ONLY
EXPAND_TABLE
NO_EXPAND_TABLE
XMLINDEX_SEL_IDX_TBL
FACTORIZE_JOIN
NO_FACTORIZE_JOIN
APPEND_VALUES
PLACE_DISTINCT
NO_PLACE_DISTINCT
NO_SUBSTRB_PAD
USE_HASH_GBY_FOR_PUSHDOWN
NO_USE_HASH_GBY_FOR_PUSHDOWN
XDB_FASTPATH_INSERT
NO_XDB_FASTPATH_INSERT
TABLE_LOOKUP_BY_NL
NO_TABLE_LOOKUP_BY_NL
FULL_OUTER_JOIN_TO_OUTER
NO_FULL_OUTER_JOIN_TO_OUTER
OUTER_JOIN_TO_ANTI
NO_OUTER_JOIN_TO_ANTI