v$sql_hint@11g
Oracle11g中的新视图V$SQL_HINT,列出了所有的hint和它们有效的Oracle版本和在outline中出现的版本。
留着用来检索了。
SQL> select name,version,version_outline from v$sql_hint order by version;
NAME VERSION VERSION_OUTLINE
———————————– ————————- ————————-
REWRITE_OR_ERROR 10.1.0.3 99.99.99.98
NO_PARTIAL_COMMIT 10.1.0.3 99.99.99.98
TRACING 10.1.0.3 99.99.99.98
SKIP_UNQ_UNUSABLE_IDX 10.1.0.3 99.99.99.98
NESTED_TABLE_FAST_INSERT 10.1.0.3 99.99.99.98
OPAQUE_TRANSFORM 10.1.0.3 99.99.99.98
OPAQUE_XCANONICAL 10.1.0.3 99.99.99.98
VECTOR_READ 10.1.0.3 99.99.99.98
VECTOR_READ_TRACE 10.1.0.3 99.99.99.98
STREAMS 10.1.0.3 99.99.99.98
USE_WEAK_NAME_RESL 10.1.0.3 99.99.99.98
NO_QUERY_TRANSFORMATION 10.1.0.3 99.99.99.98
OPTIMIZER_FEATURES_ENABLE 10.1.0.3 10.2.0.1
FBTSCAN 10.1.0.3 99.99.99.98
GATHER_PLAN_STATISTICS 10.1.0.3 99.99.99.98
IGNORE_OPTIM_EMBEDDED_HINTS 10.1.0.3 10.2.0.1
TABLE_STATS 10.1.0.3 99.99.99.98
INDEX_STATS 10.1.0.3 99.99.99.98
COLUMN_STATS 10.1.0.3 99.99.99.98
NO_STAR_TRANSFORMATION 10.1.0.3 10.1.0.3
NO_MULTIMV_REWRITE 10.1.0.3 10.1.0.3
NO_BASETABLE_MULTIMV_REWRITE 10.1.0.3 10.1.0.3
INCLUDE_VERSION 10.1.0.3 99.99.99.98
SET_TO_JOIN 10.1.0.3 10.1.0.3
NO_SET_TO_JOIN 10.1.0.3 10.1.0.3
MODEL_MIN_ANALYSIS 10.1.0.3 99.99.99.98
MODEL_NO_ANALYSIS 10.1.0.3 99.99.99.98
MODEL_PUSH_REF 10.1.0.3 99.99.99.98
NO_MODEL_PUSH_REF 10.1.0.3 99.99.99.98
MODEL_DONTVERIFY_UNIQUENESS 10.1.0.3 99.99.99.98
QB_NAME 10.1.0.3 99.99.99.98
NO_PARALLEL 10.1.0.3 99.99.99.98
NO_USE_MERGE 10.1.0.3 10.1.0.3
NO_USE_HASH 10.1.0.3 10.1.0.3
USE_NL_WITH_INDEX 10.1.0.3 99.99.99.98
NO_USE_NL 10.1.0.3 10.1.0.3
NO_INDEX_FFS 10.1.0.3 10.1.0.3
NO_INDEX_SS 10.1.0.3 10.1.0.3
NO_SWAP_JOIN_INPUTS 10.1.0.3 10.1.0.3
OPT_ESTIMATE 10.1.0.3 99.99.99.98
X_DYN_PRUNE 10.1.0.3 99.99.99.98
RESTRICT_ALL_REF_CONS 10.1.0.3 99.99.99.98
NO_CONNECT_BY_COMBINE_SW 10.1.0.6 10.2.0.4
CONNECT_BY_COMBINE_SW 10.1.0.6 10.2.0.4
INDEX_RS_DESC 10.1.0.6 10.1.0.6
INDEX_RS_ASC 10.1.0.6 10.1.0.6
PRECOMPUTE_SUBQUERY 10.2.0.1 99.99.99.98
RBO_OUTLINE 10.2.0.1 10.2.0.1
OUTLINE 10.2.0.1 10.2.0.1
OUTLINE_LEAF 10.2.0.1 10.2.0.1
OPT_PARAM 10.2.0.1 10.2.0.1
DBMS_STATS 10.2.0.1 99.99.99.98
NO_XML_DML_REWRITE 10.2.0.1 11.1.0.6
NO_SQL_TUNE 10.2.0.1 99.99.99.98
PRESERVE_OID 10.2.0.1 99.99.99.98
INLINE_XMLTYPE_NT 10.2.0.1 99.99.99.98
OLD_PUSH_PRED 10.2.0.1 10.2.0.1
PULL_PRED 10.2.0.1 10.2.0.1
NO_PULL_PRED 10.2.0.1 10.2.0.1
ELIMINATE_OBY 10.2.0.1 10.2.0.1
NO_ELIMINATE_OBY 10.2.0.1 10.2.0.1
ELIMINATE_JOIN 10.2.0.1 10.2.0.1
NO_ELIMINATE_JOIN 10.2.0.1 10.2.0.1
MODEL_DYNAMIC_SUBQUERY 10.2.0.1 99.99.99.98
MODEL_COMPILE_SUBQUERY 10.2.0.1 99.99.99.98
USE_HASH_AGGREGATION 10.2.0.1 11.1.0.6
NO_USE_HASH_AGGREGATION 10.2.0.1 11.1.0.6
BITMAP_TREE 10.2.0.1 10.2.0.1
NO_CARTESIAN 10.2.0.1 99.99.99.98
PX_JOIN_FILTER 10.2.0.1 11.1.0.6
NO_PX_JOIN_FILTER 10.2.0.1 11.1.0.6
CONNECT_BY_COST_BASED 10.2.0.2 10.2.0.2
CONNECT_BY_FILTERING 10.2.0.2 10.2.0.2
NO_CONNECT_BY_COST_BASED 10.2.0.2 10.2.0.2
NO_CONNECT_BY_FILTERING 10.2.0.2 10.2.0.2
NO_NATIVE_FULL_OUTER_JOIN 10.2.0.3 10.2.0.3
NATIVE_FULL_OUTER_JOIN 10.2.0.3 10.2.0.3
NUM_INDEX_KEYS 10.2.0.3 10.2.0.3
DB_VERSION 11.1.0.6 11.1.0.6
OUTER_JOIN_TO_INNER 11.1.0.6 11.1.0.6
NO_OUTER_JOIN_TO_INNER 11.1.0.6 11.1.0.6
GBY_PUSHDOWN 11.1.0.6 11.1.0.6
NO_GBY_PUSHDOWN 11.1.0.6 11.1.0.6
USE_MERGE_CARTESIAN 11.1.0.6 11.1.0.6
SUBQUERY_PRUNING 11.1.0.6 11.1.0.6
NO_SUBQUERY_PRUNING 11.1.0.6 11.1.0.6
DOMAIN_INDEX_FILTER 11.1.0.6 11.1.0.6
NO_DOMAIN_INDEX_FILTER 11.1.0.6 11.1.0.6
RESULT_CACHE 11.1.0.6 11.1.0.6
NO_RESULT_CACHE 11.1.0.6 11.1.0.6
XML_DML_RWT_STMT 11.1.0.6 11.1.0.6
PLACE_GROUP_BY 11.1.0.6 11.1.0.6
NO_PLACE_GROUP_BY 11.1.0.6 11.1.0.6
NO_LOAD 11.1.0.6 99.99.99.98
CHECK_ACL_REWRITE 11.1.0.6 99.99.99.98
NO_CHECK_ACL_REWRITE 11.1.0.6 99.99.99.98
XMLINDEX_REWRITE 11.1.0.6 11.1.0.6NAME VERSION VERSION_OUTLINE
———————————– ————————- ————————-
NO_XMLINDEX_REWRITE 11.1.0.6 11.1.0.6
XMLINDEX_REWRITE_IN_SELECT 11.1.0.6 11.1.0.6
NO_XMLINDEX_REWRITE_IN_SELECT 11.1.0.6 11.1.0.6
COST_XML_QUERY_REWRITE 11.1.0.6 11.1.0.6
NO_COST_XML_QUERY_REWRITE 11.1.0.6 11.1.0.6
NLJ_PREFETCH 11.1.0.6 11.1.0.6
NO_NLJ_PREFETCH 11.1.0.6 11.1.0.6
NLJ_BATCHING 11.1.0.6 11.1.0.6
NO_NLJ_BATCHING 11.1.0.6 11.1.0.6
MONITOR 11.1.0.6 99.99.99.98
NO_MONITOR 11.1.0.6 99.99.99.98
USE_INVISIBLE_INDEXES 11.1.0.6 11.1.0.6
INDEX 8.0.0 8.1.7
CLUSTER 8.0.0 8.1.7
ROWID 8.0.0 8.1.7
NO_MONITORING 8.0.0 99.99.99.98
EXPR_CORR_CHECK 8.0.0 99.99.99.98
MERGE_CONST_ON 8.0.0 99.99.99.98
QUEUE_ROWP 8.0.0 99.99.99.98
NL_AJ 8.0.0 99.99.99.98
NL_SJ 8.0.0 99.99.99.98
NO_STATS_GSETS 8.0.0 99.99.99.98
NO_ORDER_ROLLUPS 8.0.0 99.99.99.98
NO_MERGE 8.0.0 10.1.0
QUEUE_CURR 8.0.0 99.99.99.98
ORDERED_PREDICATES 8.0.0 99.99.99.98
USE_HASH 8.1.0 8.1.7
USE_NL 8.1.0 8.1.7
USE_ANTI 8.1.0 99.99.99.98
USE_SEMI 8.1.0 99.99.99.98
AND_EQUAL 8.1.0 8.1.7
INDEX_ASC 8.1.0 99.99.99.98
INDEX_DESC 8.1.0 8.1.7
INDEX_FFS 8.1.0 8.1.7
INDEX_COMBINE 8.1.0 8.1.7
HASH 8.1.0 8.1.7
PARALLEL_INDEX 8.1.0 99.99.99.98
NO_PARALLEL_INDEX 8.1.0 99.99.99.98
SWAP_JOIN_INPUTS 8.1.0 8.1.7
FACT 8.1.0 8.1.7
NO_FACT 8.1.0 8.1.7
APPEND 8.1.0 99.99.99.98
NOAPPEND 8.1.0 99.99.99.98
DEREF_NO_REWRITE 8.1.0 99.99.99.98
NESTED_TABLE_GET_REFS 8.1.0 99.99.99.98
RULE 8.1.0 8.1.5
CHOOSE 8.1.0 99.99.99.98
FIRST_ROWS 8.1.0 10.2.0.1
ALL_ROWS 8.1.0 10.2.0.1
ORDERED 8.1.0 8.1.7
PUSH_PRED 8.1.0 8.1.5
NO_PUSH_PRED 8.1.0 8.1.5
PUSH_SUBQ 8.1.0 11.1.0.6
USE_CONCAT 8.1.0 8.1.7
NO_EXPAND 8.1.0 8.1.7
SEMIJOIN_DRIVER 8.1.0 8.1.7
MERGE_AJ 8.1.0 8.1.7
HASH_AJ 8.1.0 8.1.7
MERGE_SJ 8.1.0 8.1.7
HASH_SJ 8.1.0 8.1.7
STAR 8.1.0 99.99.99.98
REMOTE_MAPPED 8.1.0 99.99.99.98
STAR_TRANSFORMATION 8.1.0 8.1.7
PIV_SSF 8.1.0 99.99.99.98
TIV_SSF 8.1.0 99.99.99.98
PIV_GB 8.1.0 99.99.99.98
TIV_GB 8.1.0 99.99.99.98
BITMAP 8.1.0 8.1.5
MERGE 8.1.0 10.1.0
FULL 8.1.0 8.1.7
SHARED 8.1.0 99.99.99.98
NOPARALLEL 8.1.0 99.99.99.98
CACHE 8.1.0 99.99.99.98
NOCACHE 8.1.0 99.99.99.98
DRIVING_SITE 8.1.0 8.1.7
USE_MERGE 8.1.0 8.1.7
PQ_DISTRIBUTE 8.1.5 8.1.7
BYPASS_UJVC 8.1.5 99.99.99.98
CACHE_CB 8.1.5 99.99.99.98
NO_BUFFER 8.1.5 99.99.99.98
BUFFER 8.1.5 99.99.99.98
SCN_ASCENDING 8.1.5 99.99.99.98
RESTORE_AS_INTERVALS 8.1.5 99.99.99.98
NO_INDEX 8.1.5 8.1.7
INDEX_JOIN 8.1.5 10.1.0.3
NO_ACCESS 8.1.5 8.1.7
NESTED_TABLE_SET_SETID 8.1.5 99.99.99.98
DOMAIN_INDEX_SORT 8.1.5 10.2.0.1
DOMAIN_INDEX_NO_SORT 8.1.5 10.2.0.1
REWRITE 8.1.5 8.1.7
NO_REWRITE 8.1.5 8.1.7
CACHE_TEMP_TABLE 8.1.5 99.99.99.98
CUBE_GB 8.1.5 99.99.99.98
SAVE_AS_INTERVALS 8.1.5 99.99.99.98
SYS_PARALLEL_TXN 8.1.6 99.99.99.98
NO_UNNEST 8.1.6 10.1.0
UNNEST 8.1.6 10.1.0NAME VERSION VERSION_OUTLINE
———————————– ————————- ————————-
LEADING 8.1.6 10.1.0.3
OR_EXPAND 8.1.7 99.99.99.98
LIKE_EXPAND 8.1.7 99.99.99.98
BYPASS_RECURSIVE_CHECK 9.0.0 99.99.99.98
INDEX_RRS 9.0.0 99.99.99.98
INDEX_SS_DESC 9.0.0 10.2.0.1
INDEX_SS_ASC 9.0.0 99.99.99.98
INDEX_SS 9.0.0 10.2.0.1
PQ_NOMAP 9.0.0 10.2.0.1
PQ_MAP 9.0.0 10.2.0.1
CARDINALITY 9.0.0 99.99.99.98
GBY_CONC_ROLLUP 9.0.0 99.99.99.98
USE_TTT_FOR_GSETS 9.0.0 99.99.99.98
NO_PRUNE_GSETS 9.0.0 99.99.99.98
MV_MERGE 9.0.0 99.99.99.98
CURSOR_SHARING_EXACT 9.0.0 99.99.99.98
SQLLDR 9.0.0 99.99.99.98
DML_UPDATE 9.0.0 99.99.99.98
SKIP_EXT_OPTIMIZER 9.0.0 99.99.99.98
CPU_COSTING 9.0.0 99.99.99.98
NO_CPU_COSTING 9.0.0 99.99.99.98
ANTIJOIN 9.0.0 99.99.99.98
SEMIJOIN 9.0.0 99.99.99.98
NO_SEMIJOIN 9.0.0 99.99.99.98
LOCAL_INDEXES 9.0.0 99.99.99.98
HWM_BROKERED 9.0.0 99.99.99.98
OVERFLOW_NOMOVE 9.0.0 99.99.99.98
MATERIALIZE 9.0.0 99.99.99.98
INLINE 9.0.0 99.99.99.98
SYS_RID_ORDER 9.2.0 99.99.99.98
NO_PUSH_SUBQ 9.2.0 11.1.0.6
NO_EXPAND_GSET_TO_UNION 9.2.0 10.1.0
NO_QKN_BUFF 9.2.0 99.99.99.98
EXPAND_GSET_TO_UNION 9.2.0 10.1.0
DYNAMIC_SAMPLING 9.2.0 99.99.99.98
REF_CASCADE_CURSOR 9.2.0 99.99.99.98
SYS_DL_CURSOR 9.2.0 99.99.99.98
IGNORE_WHERE_CLAUSE 9.2.0 99.99.99.98
NO_XML_QUERY_REWRITE 9.2.0 11.1.0.6
FORCE_XML_QUERY_REWRITE 9.2.0 11.1.0.6
NO_REF_CASCADE 9.2.0 99.99.99.98
DYNAMIC_SAMPLING_EST_CDN 9.2.0 99.99.99.98236 rows selected.
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到 POCO 网摘"){kind=logo}
