source: v$sql_hint
350 rows selected.
NAME VERSION VERSION_OUTLINE INVERSE
---------------------------------------- ------------------------- ------------------------- ----------------------------------------------------------------
APPEND 8.1.0 NOAPPEND
NOAPPEND 8.1.0 APPEND
NO_MONITORING 8.0.0
NO_SQL_TUNE 10.2.0.1
DEREF_NO_REWRITE 8.1.0
NESTED_TABLE_GET_REFS 8.1.0
PRESERVE_OID 10.2.0.1
NESTED_TABLE_SET_SETID 8.1.5
NESTED_TABLE_FAST_INSERT 10.1.0.3
INLINE_XMLTYPE_NT 10.2.0.1
REF_CASCADE_CURSOR 9.2.0 NO_REF_CASCADE
NO_REF_CASCADE 9.2.0 REF_CASCADE_CURSOR
FORCE_XML_QUERY_REWRITE 9.2.0 11.1.0.6 NO_XML_QUERY_REWRITE
NO_XML_QUERY_REWRITE 9.2.0 11.1.0.6 FORCE_XML_QUERY_REWRITE
IGNORE_WHERE_CLAUSE 9.2.0
OPAQUE_TRANSFORM 10.1.0.3
OPAQUE_XCANONICAL 10.1.0.3
SYS_DL_CURSOR 9.2.0
SQLLDR 9.0.0
DML_UPDATE 9.0.0
VECTOR_READ 10.1.0.3
VECTOR_READ_TRACE 10.1.0.3
EXPR_CORR_CHECK 8.0.0
STREAMS 10.1.0.3
MERGE_CONST_ON 8.0.0
USE_WEAK_NAME_RESL 10.1.0.3
NO_QUERY_TRANSFORMATION 10.1.0.3
OPTIMIZER_FEATURES_ENABLE 10.1.0.3 10.2.0.1
DB_VERSION 11.1.0.6 11.1.0.6
FBTSCAN 10.1.0.3
GATHER_PLAN_STATISTICS 10.1.0.3
IGNORE_OPTIM_EMBEDDED_HINTS 10.1.0.3 10.2.0.1
TABLE_STATS 10.1.0.3
INDEX_STATS 10.1.0.3
COLUMN_STATS 10.1.0.3
RULE 8.1.0 8.1.5
CHOOSE 8.1.0
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
ORDERED_PREDICATES 8.0.0
DOMAIN_INDEX_SORT 8.1.5 10.2.0.1 DOMAIN_INDEX_NO_SORT
DOMAIN_INDEX_NO_SORT 8.1.5 10.2.0.1 DOMAIN_INDEX_SORT
SKIP_EXT_OPTIMIZER 9.0.0
CPU_COSTING 9.0.0 NO_CPU_COSTING
NO_CPU_COSTING 9.0.0 CPU_COSTING
OLD_PUSH_PRED 10.2.0.1 10.2.0.1
PUSH_PRED 8.1.0 8.1.5 NO_PUSH_PRED
NO_PUSH_PRED 8.1.0 8.1.5 PUSH_PRED
PULL_PRED 10.2.0.1 10.2.0.1 NO_PULL_PRED
NO_PULL_PRED 10.2.0.1 10.2.0.1 PULL_PRED
ELIMINATE_OBY 10.2.0.1 10.2.0.1 NO_ELIMINATE_OBY
NO_ELIMINATE_OBY 10.2.0.1 10.2.0.1 ELIMINATE_OBY
ELIMINATE_JOIN 10.2.0.1 10.2.0.1 NO_ELIMINATE_JOIN
NO_ELIMINATE_JOIN 10.2.0.1 10.2.0.1 ELIMINATE_JOIN
OUTER_JOIN_TO_INNER 11.1.0.6 11.1.0.6 NO_OUTER_JOIN_TO_INNER
NO_OUTER_JOIN_TO_INNER 11.1.0.6 11.1.0.6 OUTER_JOIN_TO_INNER
PUSH_SUBQ 8.1.0 10.2.0.5 NO_PUSH_SUBQ
NO_PUSH_SUBQ 9.2.0 10.2.0.5 PUSH_SUBQ
GBY_PUSHDOWN 10.2.0.5 10.2.0.5 NO_GBY_PUSHDOWN
NO_GBY_PUSHDOWN 10.2.0.5 10.2.0.5 GBY_PUSHDOWN
USE_CONCAT 8.1.0 8.1.7 NO_EXPAND
NO_EXPAND 8.1.0 8.1.7 USE_CONCAT
SEMIJOIN_DRIVER 8.1.0 8.1.7
ANTIJOIN 9.0.0
MERGE_AJ 8.1.0 8.1.7
HASH_AJ 8.1.0 8.1.7
NL_AJ 8.0.0
SEMIJOIN 9.0.0 NO_SEMIJOIN
NO_SEMIJOIN 9.0.0 SEMIJOIN
MERGE_SJ 8.1.0 8.1.7
HASH_SJ 8.1.0 8.1.7
NL_SJ 8.0.0
STAR 8.1.0
REMOTE_MAPPED 8.1.0
STAR_TRANSFORMATION 8.1.0 8.1.7 NO_STAR_TRANSFORMATION
NO_STAR_TRANSFORMATION 10.1.0.3 10.1.0.3 STAR_TRANSFORMATION
REWRITE 8.1.5 8.1.7 NO_REWRITE
NO_REWRITE 8.1.5 8.1.7 REWRITE
NO_MULTIMV_REWRITE 10.1.0.3 10.1.0.3 REWRITE
NO_BASETABLE_MULTIMV_REWRITE 10.1.0.3 10.1.0.3 REWRITE
REWRITE_OR_ERROR 10.1.0.3
BYPASS_UJVC 8.1.5
UNNEST 8.1.6 10.1.0 NO_UNNEST
NO_UNNEST 8.1.6 10.1.0 UNNEST
LOCAL_INDEXES 9.0.0
HWM_BROKERED 9.0.0
OVERFLOW_NOMOVE 9.0.0
SYS_PARALLEL_TXN 8.1.6
SYS_RID_ORDER 9.2.0
BYPASS_RECURSIVE_CHECK 9.0.0
MATERIALIZE 9.0.0 INLINE
INLINE 9.0.0 MATERIALIZE
CONNECT_BY_COST_BASED 10.2.0.2 10.2.0.2 NO_CONNECT_BY_COST_BASED
NO_CONNECT_BY_COST_BASED 10.2.0.2 10.2.0.2 CONNECT_BY_COST_BASED
CONNECT_BY_FILTERING 10.2.0.2 10.2.0.2 NO_CONNECT_BY_FILTERING
NO_CONNECT_BY_FILTERING 10.2.0.2 10.2.0.2 CONNECT_BY_FILTERING
SET_TO_JOIN 10.1.0.3 10.1.0.3 NO_SET_TO_JOIN
NO_SET_TO_JOIN 10.1.0.3 10.1.0.3 SET_TO_JOIN
PIV_SSF 8.1.0
TIV_SSF 8.1.0
PIV_GB 8.1.0
TIV_GB 8.1.0
CUBE_GB 8.1.5
SAVE_AS_INTERVALS 8.1.5
RESTORE_AS_INTERVALS 8.1.5
BITMAP 8.1.0 8.1.5
SCN_ASCENDING 8.1.5
NO_QKN_BUFF 9.2.0
BUFFER 8.1.5 NO_BUFFER
NO_BUFFER 8.1.5 BUFFER
CURSOR_SHARING_EXACT 9.0.0
MV_MERGE 9.0.0
EXPAND_GSET_TO_UNION 9.2.0 10.1.0 NO_EXPAND_GSET_TO_UNION
NO_EXPAND_GSET_TO_UNION 9.2.0 10.1.0 EXPAND_GSET_TO_UNION
MODEL_MIN_ANALYSIS 10.1.0.3
MODEL_NO_ANALYSIS 10.1.0.3
MODEL_DYNAMIC_SUBQUERY 10.2.0.1
MODEL_COMPILE_SUBQUERY 10.2.0.1
MODEL_PUSH_REF 10.1.0.3 NO_MODEL_PUSH_REF
NO_MODEL_PUSH_REF 10.1.0.3 MODEL_PUSH_REF
MODEL_DONTVERIFY_UNIQUENESS 10.1.0.3
NO_PRUNE_GSETS 9.0.0
USE_TTT_FOR_GSETS 9.0.0
USE_HASH_AGGREGATION 10.2.0.1 10.2.0.5 NO_USE_HASH_AGGREGATION
NO_USE_HASH_AGGREGATION 10.2.0.1 10.2.0.5 USE_HASH_AGGREGATION
GBY_CONC_ROLLUP 9.0.0
NO_STATS_GSETS 8.0.0
NO_ORDER_ROLLUPS 8.0.0
QB_NAME 10.1.0.3
DYNAMIC_SAMPLING 9.2.0
CARDINALITY 9.0.0
LEADING 8.1.6 10.1.0.3
MERGE 8.1.0 10.1.0 NO_MERGE
NO_MERGE 8.0.0 10.1.0 MERGE
FULL 8.1.0 8.1.7
SHARED 8.1.0 NO_PARALLEL
NOPARALLEL 8.1.0 SHARED
NO_PARALLEL 10.1.0.3 SHARED
CACHE_CB 8.1.5 NOCACHE
CACHE 8.1.0 NOCACHE
NOCACHE 8.1.0 CACHE
DRIVING_SITE 8.1.0 8.1.7
QUEUE_CURR 8.0.0
QUEUE_ROWP 8.0.0
USE_MERGE_CARTESIAN 11.1.0.6 11.1.0.6
USE_MERGE 8.1.0 8.1.7 NO_USE_MERGE
NO_USE_MERGE 10.1.0.3 10.1.0.3 USE_MERGE
USE_HASH 8.1.0 8.1.7 NO_USE_HASH
NO_USE_HASH 10.1.0.3 10.1.0.3 USE_HASH
USE_NL 8.1.0 8.1.7 NO_USE_NL
USE_NL_WITH_INDEX 10.1.0.3 NO_USE_NL
NO_USE_NL 10.1.0.3 10.1.0.3 USE_NL
USE_ANTI 8.1.0
USE_SEMI 8.1.0
PQ_DISTRIBUTE 8.1.5 8.1.7
SUBQUERY_PRUNING 11.1.0.6 11.1.0.6 NO_SUBQUERY_PRUNING
NO_SUBQUERY_PRUNING 11.1.0.6 11.1.0.6 SUBQUERY_PRUNING
PQ_MAP 9.0.0 10.2.0.1 PQ_NOMAP
PQ_NOMAP 9.0.0 10.2.0.1 PQ_MAP
AND_EQUAL 8.1.0 8.1.7
INDEX_ASC 8.1.0 NO_INDEX
INDEX 8.0.0 8.1.7 NO_INDEX
INDEX_DESC 8.1.0 8.1.7 NO_INDEX
NO_INDEX 8.1.5 8.1.7 INDEX
INDEX_FFS 8.1.0 8.1.7
NO_INDEX_FFS 10.1.0.3 10.1.0.3 INDEX_FFS
INDEX_SS 9.0.0 10.2.0.1 NO_INDEX_SS
INDEX_SS_ASC 9.0.0 NO_INDEX_SS
INDEX_SS_DESC 9.0.0 10.2.0.1 NO_INDEX_SS
NO_INDEX_SS 10.1.0.3 10.1.0.3 INDEX_SS
INDEX_COMBINE 8.1.0 8.1.7
BITMAP_TREE 10.2.0.1 10.2.0.1
INDEX_JOIN 8.1.5 10.1.0.3
INDEX_RRS 9.0.0
HASH 8.1.0 8.1.7
PARALLEL_INDEX 8.1.0 NO_PARALLEL_INDEX
NO_PARALLEL_INDEX 8.1.0 PARALLEL_INDEX
SWAP_JOIN_INPUTS 8.1.0 8.1.7 NO_SWAP_JOIN_INPUTS
NO_SWAP_JOIN_INPUTS 10.1.0.3 10.1.0.3 SWAP_JOIN_INPUTS
FACT 8.1.0 8.1.7 NO_FACT
NO_FACT 8.1.0 8.1.7 FACT
NO_ACCESS 8.1.5 8.1.7
DYNAMIC_SAMPLING_EST_CDN 9.2.0
CLUSTER 8.0.0 8.1.7
ROWID 8.0.0 8.1.7
OPT_ESTIMATE 10.1.0.3
X_DYN_PRUNE 10.1.0.3
RESTRICT_ALL_REF_CONS 10.1.0.3
SKIP_UNQ_UNUSABLE_IDX 10.1.0.3
TRACING 10.1.0.3
NO_PARTIAL_COMMIT 10.1.0.3
INCLUDE_VERSION 10.1.0.3
NO_CARTESIAN 10.2.0.1
PX_JOIN_FILTER 10.2.0.1 11.1.0.6 NO_PX_JOIN_FILTER
NO_PX_JOIN_FILTER 10.2.0.1 11.1.0.6 PX_JOIN_FILTER
PRECOMPUTE_SUBQUERY 10.2.0.1
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
DOMAIN_INDEX_FILTER 11.1.0.6 11.1.0.6 NO_DOMAIN_INDEX_FILTER
NO_DOMAIN_INDEX_FILTER 11.1.0.6 11.1.0.6 DOMAIN_INDEX_FILTER
RESULT_CACHE 11.1.0.6 NO_RESULT_CACHE
NO_RESULT_CACHE 11.1.0.6 RESULT_CACHE
NO_XML_DML_REWRITE 10.2.0.1 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
NO_PLACE_GROUP_BY 11.1.0.6 11.1.0.6 PLACE_GROUP_BY
INDEX_RS_ASC 11.1.0.6 11.1.0.6
INDEX_RS_DESC 11.1.0.6 11.1.0.6
NO_LOAD 11.1.0.6
NUM_INDEX_KEYS 10.2.0.3 10.2.0.3
CHECK_ACL_REWRITE 11.1.0.6 NO_CHECK_ACL_REWRITE
NO_CHECK_ACL_REWRITE 11.1.0.6 CHECK_ACL_REWRITE
CONNECT_BY_COMBINE_SW 10.2.0.4 10.2.0.4 NO_CONNECT_BY_COMBINE_SW
NO_CONNECT_BY_COMBINE_SW 10.2.0.4 10.2.0.4 CONNECT_BY_COMBINE_SW
XMLINDEX_REWRITE 11.1.0.6 11.1.0.6 NO_XMLINDEX_REWRITE
NO_XMLINDEX_REWRITE 11.1.0.6 11.1.0.6 XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT 11.1.0.6 11.1.0.6 NO_XMLINDEX_REWRITE_IN_SELECT
NO_XMLINDEX_REWRITE_IN_SELECT 11.1.0.6 11.1.0.6 XMLINDEX_REWRITE_IN_SELECT
NATIVE_FULL_OUTER_JOIN 10.2.0.3 10.2.0.3 NO_NATIVE_FULL_OUTER_JOIN
NO_NATIVE_FULL_OUTER_JOIN 10.2.0.3 10.2.0.3 NATIVE_FULL_OUTER_JOIN
COST_XML_QUERY_REWRITE 11.1.0.6 11.1.0.6 NO_COST_XML_QUERY_REWRITE
NO_COST_XML_QUERY_REWRITE 11.1.0.6 11.1.0.6 COST_XML_QUERY_REWRITE
NLJ_PREFETCH 11.1.0.6 11.1.0.6 NO_NLJ_PREFETCH
NO_NLJ_PREFETCH 11.1.0.6 11.1.0.6 NLJ_PREFETCH
NLJ_BATCHING 11.1.0.6 11.1.0.6 NO_NLJ_BATCHING
NO_NLJ_BATCHING 11.1.0.6 11.1.0.6 NLJ_BATCHING
MONITOR 11.1.0.6 NO_MONITOR
NO_MONITOR 11.1.0.6 MONITOR
USE_INVISIBLE_INDEXES 11.1.0.6 11.1.0.6 NO_USE_INVISIBLE_INDEXES
NO_USE_INVISIBLE_INDEXES 11.1.0.6 11.1.0.6 USE_INVISIBLE_INDEXES
BIND_AWARE 11.1.0.7 NO_BIND_AWARE
NO_BIND_AWARE 11.1.0.7 BIND_AWARE
IGNORE_ROW_ON_DUPKEY_INDEX 11.1.0.7
CHANGE_DUPKEY_ERROR_INDEX 11.1.0.7
RETRY_ON_ROW_CHANGE 11.1.0.7
COALESCE_SQ 11.2.0.1 11.2.0.1 NO_COALESCE_SQ
NO_COALESCE_SQ 11.2.0.1 11.2.0.1 COALESCE_SQ
TRANSFORM_DISTINCT_AGG 11.2.0.1 11.2.0.1 NO_TRANSFORM_DISTINCT_AGG
NO_TRANSFORM_DISTINCT_AGG 11.2.0.1 11.2.0.1 TRANSFORM_DISTINCT_AGG
CONNECT_BY_ELIM_DUPS 11.2.0.1 11.2.0.1 NO_CONNECT_BY_ELIM_DUPS
NO_CONNECT_BY_ELIM_DUPS 11.2.0.1 11.2.0.1 CONNECT_BY_ELIM_DUPS
DST_UPGRADE_INSERT_CONV 11.2.0.1 NO_DST_UPGRADE_INSERT_CONV
NO_DST_UPGRADE_INSERT_CONV 11.2.0.1 12.2.0.2 DST_UPGRADE_INSERT_CONV
STATEMENT_QUEUING 11.2.0.1 NO_STATEMENT_QUEUING
NO_STATEMENT_QUEUING 11.2.0.1 STATEMENT_QUEUING
CONNECT_BY_CB_WHR_ONLY 10.2.0.5 10.2.0.5 NO_CONNECT_BY_CB_WHR_ONLY
NO_CONNECT_BY_CB_WHR_ONLY 10.2.0.5 10.2.0.5 CONNECT_BY_CB_WHR_ONLY
EXPAND_TABLE 11.2.0.1 11.2.0.1 NO_EXPAND_TABLE
NO_EXPAND_TABLE 11.2.0.1 11.2.0.1 EXPAND_TABLE
XMLINDEX_SEL_IDX_TBL 11.2.0.1
XMLTSET_DML_ENABLE 12.2.0.1
FACTORIZE_JOIN 11.2.0.1 11.2.0.1 NO_FACTORIZE_JOIN
NO_FACTORIZE_JOIN 11.2.0.1 11.2.0.1 FACTORIZE_JOIN
APPEND_VALUES 11.2.0.1 NOAPPEND
PLACE_DISTINCT 11.2.0.1 11.2.0.1 NO_PLACE_DISTINCT
NO_PLACE_DISTINCT 11.2.0.1 11.2.0.1 PLACE_DISTINCT
NO_SUBSTRB_PAD 11.2.0.1
USE_HASH_GBY_FOR_PUSHDOWN 11.2.0.2 11.2.0.2 NO_USE_HASH_GBY_FOR_PUSHDOWN
NO_USE_HASH_GBY_FOR_PUSHDOWN 11.2.0.2 11.2.0.2 USE_HASH_GBY_FOR_PUSHDOWN
XDB_FASTPATH_INSERT 11.2.0.2 NO_XDB_FASTPATH_INSERT
NO_XDB_FASTPATH_INSERT 11.2.0.2 XDB_FASTPATH_INSERT
TABLE_LOOKUP_BY_NL 11.2.0.2 11.2.0.2 NO_TABLE_LOOKUP_BY_NL
NO_TABLE_LOOKUP_BY_NL 11.2.0.2 11.2.0.2 TABLE_LOOKUP_BY_NL
DATA_SECURITY_REWRITE_LIMIT 12.1.0.1 12.1.0.1 NO_DATA_SECURITY_REWRITE
NO_DATA_SECURITY_REWRITE 12.1.0.1 12.1.0.1 DATA_SECURITY_REWRITE_LIMIT
USE_CUBE 12.1.0.1 12.1.0.1 NO_USE_CUBE
NO_USE_CUBE 12.1.0.1 12.1.0.1 USE_CUBE
CUBE_SJ 12.1.0.1 12.1.0.1
CUBE_AJ 12.1.0.1 12.1.0.1
SEMI_TO_INNER 11.2.0.3 11.2.0.3 NO_SEMI_TO_INNER
NO_SEMI_TO_INNER 11.2.0.3 11.2.0.3 SEMI_TO_INNER
PARTIAL_JOIN 12.1.0.1 12.1.0.1 NO_PARTIAL_JOIN
NO_PARTIAL_JOIN 12.1.0.1 12.1.0.1 PARTIAL_JOIN
PQ_CONCURRENT_UNION 12.1.0.1 12.1.0.1 NO_PQ_CONCURRENT_UNION
NO_PQ_CONCURRENT_UNION 12.1.0.1 12.1.0.1 PQ_CONCURRENT_UNION
CLUSTERING 12.1.0.1 12.1.0.1 NO_CLUSTERING
NO_CLUSTERING 12.1.0.1 12.1.0.1 CLUSTERING
ZONEMAP 12.1.0.1 12.1.0.1 NO_ZONEMAP
NO_ZONEMAP 12.1.0.1 12.1.0.1 ZONEMAP
PQ_REPLICATE 12.1.0.1 12.1.0.1 NO_PQ_REPLICATE
NO_PQ_REPLICATE 12.1.0.1 12.1.0.1 PQ_REPLICATE
FULL_OUTER_JOIN_TO_OUTER 11.2.0.3 11.2.0.3 NO_FULL_OUTER_JOIN_TO_OUTER
NO_FULL_OUTER_JOIN_TO_OUTER 11.2.0.3 11.2.0.3 FULL_OUTER_JOIN_TO_OUTER
OUTER_JOIN_TO_ANTI 11.2.0.3 11.2.0.3 NO_OUTER_JOIN_TO_ANTI
NO_OUTER_JOIN_TO_ANTI 11.2.0.3 11.2.0.3 OUTER_JOIN_TO_ANTI
PQ_FILTER 12.1.0.1 12.1.0.1
DECORRELATE 12.1.0.1 12.1.0.1 NO_DECORRELATE
NO_DECORRELATE 12.1.0.1 12.1.0.1 DECORRELATE
BATCH_TABLE_ACCESS_BY_ROWID 12.1.0.1 12.1.0.1 NO_BATCH_TABLE_ACCESS_BY_ROWID
NO_BATCH_TABLE_ACCESS_BY_ROWID 12.1.0.1 12.1.0.1 BATCH_TABLE_ACCESS_BY_ROWID
PQ_SKEW 12.1.0.1 12.1.0.1 NO_PQ_SKEW
NO_PQ_SKEW 12.1.0.1 12.1.0.1 PQ_SKEW
PX_FAULT_TOLERANCE 12.1.0.1 12.1.0.1 NO_PX_FAULT_TOLERANCE
NO_PX_FAULT_TOLERANCE 12.1.0.1 12.1.0.1 PX_FAULT_TOLERANCE
PARTIAL_ROLLUP_PUSHDOWN 12.1.0.1 12.1.0.1 NO_PARTIAL_ROLLUP_PUSHDOWN
NO_PARTIAL_ROLLUP_PUSHDOWN 12.1.0.1 12.1.0.1 PARTIAL_ROLLUP_PUSHDOWN
USE_HIDDEN_PARTITIONS 12.1.0.1
PQ_DISTRIBUTE_WINDOW 12.1.0.1 12.1.0.1
AUTO_REOPTIMIZE 12.1.0.1 NO_AUTO_REOPTIMIZE
NO_AUTO_REOPTIMIZE 12.1.0.1 AUTO_REOPTIMIZE
BITMAP_AND 12.1.0.1 12.1.0.1
ENABLE_PARALLEL_DML 11.2.0.4 DISABLE_PARALLEL_DML
DISABLE_PARALLEL_DML 11.2.0.4 ENABLE_PARALLEL_DML
GATHER_OPTIMIZER_STATISTICS 12.1.0.1 NO_GATHER_OPTIMIZER_STATISTICS
NO_GATHER_OPTIMIZER_STATISTICS 12.1.0.1 GATHER_OPTIMIZER_STATISTICS
WITH_PLSQL 12.1.0.1
CLUSTER_BY_ROWID 12.1.0.1 12.1.0.1 NO_CLUSTER_BY_ROWID
NO_CLUSTER_BY_ROWID 12.1.0.1 12.1.0.1 CLUSTER_BY_ROWID
VECTOR_TRANSFORM_FACT 12.1.0.2 12.1.0.2 NO_VECTOR_TRANSFORM_FACT
NO_VECTOR_TRANSFORM_FACT 12.1.0.2 12.1.0.2 VECTOR_TRANSFORM_FACT
VECTOR_TRANSFORM_DIMS 12.1.0.2 12.1.0.2 NO_VECTOR_TRANSFORM_DIMS
NO_VECTOR_TRANSFORM_DIMS 12.1.0.2 12.1.0.2 VECTOR_TRANSFORM_DIMS
VECTOR_TRANSFORM 12.1.0.2 12.1.0.2 NO_VECTOR_TRANSFORM
NO_VECTOR_TRANSFORM 12.1.0.2 12.1.0.2 VECTOR_TRANSFORM
USE_VECTOR_AGGREGATION 12.1.0.2 12.1.0.2 NO_USE_VECTOR_AGGREGATION
NO_USE_VECTOR_AGGREGATION 12.1.0.2 12.1.0.2 USE_VECTOR_AGGREGATION
ANSI_REARCH 12.1.0.2 12.1.0.2 NO_ANSI_REARCH
NO_ANSI_REARCH 12.1.0.2 12.1.0.2 ANSI_REARCH
ELIM_GROUPBY 12.1.0.2 12.1.0.2 NO_ELIM_GROUPBY
NO_ELIM_GROUPBY 12.1.0.2 12.1.0.2 ELIM_GROUPBY
ADAPTIVE_PLAN 12.1.0.2 12.1.0.2 NO_ADAPTIVE_PLAN
NO_ADAPTIVE_PLAN 12.1.0.2 12.1.0.2 ADAPTIVE_PLAN
INMEMORY 12.1.0.2 12.1.0.2 NO_INMEMORY
NO_INMEMORY 12.1.0.2 12.1.0.2 INMEMORY
INMEMORY_PRUNING 12.1.0.2 12.1.0.2 NO_INMEMORY_PRUNING
NO_INMEMORY_PRUNING 12.1.0.2 12.1.0.2 INMEMORY_PRUNING
ORDER_SUBQ 12.2.0.1 12.2.0.1
FRESH_MV 12.2.0.1
RESERVOIR_SAMPLING 12.1.0.2
BUSHY_JOIN 12.2.0.1 12.2.0.1 NO_BUSHY_JOIN
NO_BUSHY_JOIN 12.2.0.1 12.2.0.1 BUSHY_JOIN
ELIMINATE_SQ 12.2.0.1 12.2.0.1 NO_ELIMINATE_SQ
NO_ELIMINATE_SQ 12.2.0.1 12.2.0.1 ELIMINATE_SQ
OR_EXPAND 12.2.0.1 12.2.0.1 NO_OR_EXPAND
NO_OR_EXPAND 12.2.0.1 12.2.0.1 OR_EXPAND
USE_HASH_GBY_FOR_DAGGPSHD 12.2.0.1 12.2.0.1 NO_USE_HASH_GBY_FOR_DAGGPSHD
NO_USE_HASH_GBY_FOR_DAGGPSHD 12.2.0.1 12.2.0.1 USE_HASH_GBY_FOR_DAGGPSHD
CONTAINERS 12.2.0.1 12.2.0.1
USE_DAGG_UNION_ALL_GSETS 12.2.0.1 12.2.0.1 NO_USE_DAGG_UNION_ALL_GSETS
NO_USE_DAGG_UNION_ALL_GSETS 12.2.0.1 12.2.0.1 USE_DAGG_UNION_ALL_GSETS
DATA_VALIDATE 12.2.0.1
DIST_AGG_PROLLUP_PUSHDOWN 12.2.0.1 12.2.0.1 NO_DIST_AGG_PROLLUP_PUSHDOWN
NO_DIST_AGG_PROLLUP_PUSHDOWN 12.2.0.1 12.2.0.1 DIST_AGG_PROLLUP_PUSHDOWN
USE_PARTITION_WISE_DISTINCT 12.2.0.1 12.2.0.1 NO_USE_PARTITION_WISE_DISTINCT
NO_USE_PARTITION_WISE_DISTINCT 12.2.0.1 12.2.0.1 USE_PARTITION_WISE_DISTINCT
SQL_SCOPE 12.2.0.1
350 rows selected.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
