Oracle 12.2.0.1 SQL HINT
source: v$sql_hint
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.
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。