オンプレミス版Oracle12c R2リリース！
OTNでOracle12c R2がダウンロード出来るようになったので早速手元環境にインストールしてみた。
SQL> select BANNER from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production PL/SQL Release 12.2.0.1.0 - Production CORE 12.2.0.1.0 Production TNS for Linux: Version 12.2.0.1.0 - Production NLSRTL Version 12.2.0.1.0 - Production
新しく追加されたヒント句を確認する
以前12cR1までのヒント句の変遷を追ってみたことがある。Oracleバージョンによるヒント句の変遷 参照
今回のバージョンアップで新たに追加されたヒント句を確認してみよう。
SQL> SELECT VERSION,NAME HINT_NAME,INVERSE,CLASS,SQL_FEATURE
2 FROM V$SQL_HINT
3 ORDER BY
4 TO_NUMBER(REGEXP_REPLACE(REGEXP_REPLACE(VERSION,'\.','',1,2),'\.','',1,2),99.999) DESC
5 ,CLASS,NAME;
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
12.2.0.1 BUSHY_JOIN NO_BUSHY_JOIN BUSHY_JOIN QKSFM_BUSHY_JOIN
NO_BUSHY_JOIN BUSHY_JOIN BUSHY_JOIN QKSFM_BUSHY_JOIN
CONTAINERS CONTAINERS QKSFM_ALL
DATA_VALIDATE DATA_VALIDATE QKSFM_EXECUTION
DIST_AGG_PROLLUP_PUSHDOWN NO_DIST_AGG_PROLLUP_PUSHDOWN DIST_AGG_PROLLUP_PUSHDOWN QKSFM_PQ
NO_DIST_AGG_PROLLUP_PUSHDOWN DIST_AGG_PROLLUP_PUSHDOWN DIST_AGG_PROLLUP_PUSHDOWN QKSFM_PQ
ELIMINATE_SQ NO_ELIMINATE_SQ ELIMINATE_SQ QKSFM_ELIMINATE_SQ
NO_ELIMINATE_SQ ELIMINATE_SQ ELIMINATE_SQ QKSFM_ELIMINATE_SQ
FRESH_MV FRESH_MV QKSFM_MVIEWS
ORDER_SUBQ ORDER_SUBQ QKSFM_TRANSFORMATION
NO_OR_EXPAND OR_EXPAND OR_EXPAND QKSFM_CBQT_OR_EXPANSION
OR_EXPAND NO_OR_EXPAND OR_EXPAND QKSFM_CBQT_OR_EXPANSION
SQL_SCOPE SQL_SCOPE QKSFM_COMPILATION
NO_USE_DAGG_UNION_ALL_GSETS USE_DAGG_UNION_ALL_GSETS USE_DAGG_UNION_ALL_GSETS QKSFM_GROUPING_SET_XFORM
USE_DAGG_UNION_ALL_GSETS NO_USE_DAGG_UNION_ALL_GSETS USE_DAGG_UNION_ALL_GSETS QKSFM_GROUPING_SET_XFORM
NO_USE_HASH_GBY_FOR_DAGGPSHD USE_HASH_GBY_FOR_DAGGPSHD USE_HASH_GBY_FOR_DAGGPSHD QKSFM_ALL
USE_HASH_GBY_FOR_DAGGPSHD NO_USE_HASH_GBY_FOR_DAGGPSHD USE_HASH_GBY_FOR_DAGGPSHD QKSFM_ALL
NO_USE_PARTITION_WISE_DISTINCT USE_PARTITION_WISE_DISTINCT USE_PARTITION_WISE_DISTINCT QKSFM_PARTITION
USE_PARTITION_WISE_DISTINCT NO_USE_PARTITION_WISE_DISTINCT USE_PARTITION_WISE_DISTINCT QKSFM_PARTITION
NO_USE_PARTITION_WISE_GBY USE_PARTITION_WISE_GBY USE_PARTITION_WISE_GBY QKSFM_PARTITION
USE_PARTITION_WISE_GBY NO_USE_PARTITION_WISE_GBY USE_PARTITION_WISE_GBY QKSFM_PARTITION
XMLTSET_DML_ENABLE XMLTSET_DML_ENABLE QKSFM_ALL
********* ------------------------------
count 22
12cR2では新たに22個のヒント句が追加された。（トータルでは352個）
12cR1までのヒント一覧
12cR1までのヒント句を以下に再掲する。（バージョンの降順）
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
12.1.0.2 ADAPTIVE_PLAN NO_ADAPTIVE_PLAN ADAPTIVE_PLAN QKSFM_ADAPTIVE_PLAN
NO_ADAPTIVE_PLAN ADAPTIVE_PLAN ADAPTIVE_PLAN QKSFM_ADAPTIVE_PLAN
ANSI_REARCH NO_ANSI_REARCH ANSI_REARCH QKSFM_ANSI_REARCH
NO_ANSI_REARCH ANSI_REARCH ANSI_REARCH QKSFM_ANSI_REARCH
ELIM_GROUPBY NO_ELIM_GROUPBY ELIM_GROUPBY QKSFM_TRANSFORMATION
NO_ELIM_GROUPBY ELIM_GROUPBY ELIM_GROUPBY QKSFM_TRANSFORMATION
INMEMORY NO_INMEMORY INMEMORY QKSFM_EXECUTION
NO_INMEMORY INMEMORY INMEMORY QKSFM_EXECUTION
INMEMORY_PRUNING NO_INMEMORY_PRUNING INMEMORY_PRUNING QKSFM_EXECUTION
NO_INMEMORY_PRUNING INMEMORY_PRUNING INMEMORY_PRUNING QKSFM_EXECUTION
RESERVOIR_SAMPLING RESERVOIR_SAMPLING QKSFM_EXECUTION
NO_USE_VECTOR_AGGREGATION USE_VECTOR_AGGREGATION USE_VECTOR_AGGREGATION QKSFM_VECTOR_AGG
USE_VECTOR_AGGREGATION NO_USE_VECTOR_AGGREGATION USE_VECTOR_AGGREGATION QKSFM_VECTOR_AGG
NO_VECTOR_TRANSFORM VECTOR_TRANSFORM VECTOR_TRANSFORM QKSFM_VECTOR_AGG
VECTOR_TRANSFORM NO_VECTOR_TRANSFORM VECTOR_TRANSFORM QKSFM_VECTOR_AGG
NO_VECTOR_TRANSFORM_DIMS VECTOR_TRANSFORM_DIMS VECTOR_TRANSFORM_DIMS QKSFM_VECTOR_AGG
VECTOR_TRANSFORM_DIMS NO_VECTOR_TRANSFORM_DIMS VECTOR_TRANSFORM_DIMS QKSFM_VECTOR_AGG
NO_VECTOR_TRANSFORM_FACT VECTOR_TRANSFORM_FACT VECTOR_TRANSFORM_FACT QKSFM_VECTOR_AGG
VECTOR_TRANSFORM_FACT NO_VECTOR_TRANSFORM_FACT VECTOR_TRANSFORM_FACT QKSFM_VECTOR_AGG
********* ------------------------------
count 19
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
12.1.0.1 CUBE_AJ ANTIJOIN QKSFM_JOIN_METHOD
AUTO_REOPTIMIZE NO_AUTO_REOPTIMIZE AUTO_REOPTIMIZE QKSFM_AUTO_REOPT
NO_AUTO_REOPTIMIZE AUTO_REOPTIMIZE AUTO_REOPTIMIZE QKSFM_AUTO_REOPT
BATCH_TABLE_ACCESS_BY_ROWID NO_BATCH_TABLE_ACCESS_BY_ROWID BATCH_TABLE_ACCESS_BY_ROWID QKSFM_EXECUTION
NO_BATCH_TABLE_ACCESS_BY_ROWID BATCH_TABLE_ACCESS_BY_ROWID BATCH_TABLE_ACCESS_BY_ROWID QKSFM_EXECUTION
BITMAP_AND BITMAP_AND QKSFM_BITMAP_TREE
CLUSTERING NO_CLUSTERING CLUSTERING QKSFM_CLUSTERING
NO_CLUSTERING CLUSTERING CLUSTERING QKSFM_CLUSTERING
CLUSTER_BY_ROWID NO_CLUSTER_BY_ROWID CLUSTER_BY_ROWID QKSFM_CBO
NO_CLUSTER_BY_ROWID CLUSTER_BY_ROWID CLUSTER_BY_ROWID QKSFM_CBO
DATA_SECURITY_REWRITE_LIMIT NO_DATA_SECURITY_REWRITE DATA_SECURITY_REWRITE_LIMIT QKSFM_DATA_SECURITY_REWRITE
NO_DATA_SECURITY_REWRITE DATA_SECURITY_REWRITE_LIMIT DATA_SECURITY_REWRITE_LIMIT QKSFM_DATA_SECURITY_REWRITE
DECORRELATE NO_DECORRELATE DECORRELATE QKSFM_DECORRELATE
NO_DECORRELATE DECORRELATE DECORRELATE QKSFM_DECORRELATE
GATHER_OPTIMIZER_STATISTICS NO_GATHER_OPTIMIZER_STATISTICS GATHER_OPTIMIZER_STATISTICS QKSFM_DBMS_STATS
NO_GATHER_OPTIMIZER_STATISTICS GATHER_OPTIMIZER_STATISTICS GATHER_OPTIMIZER_STATISTICS QKSFM_DBMS_STATS
NO_USE_CUBE USE_CUBE JOIN QKSFM_USE_CUBE
USE_CUBE NO_USE_CUBE JOIN QKSFM_USE_CUBE
NO_PARTIAL_JOIN PARTIAL_JOIN PARTIAL_JOIN QKSFM_PARTIAL_JOIN
PARTIAL_JOIN NO_PARTIAL_JOIN PARTIAL_JOIN QKSFM_PARTIAL_JOIN
NO_PARTIAL_ROLLUP_PUSHDOWN PARTIAL_ROLLUP_PUSHDOWN PARTIAL_ROLLUP_PUSHDOWN QKSFM_PQ
PARTIAL_ROLLUP_PUSHDOWN NO_PARTIAL_ROLLUP_PUSHDOWN PARTIAL_ROLLUP_PUSHDOWN QKSFM_PQ
NO_PQ_CONCURRENT_UNION PQ_CONCURRENT_UNION PQ_CONCURRENT_UNION QKSFM_PQ
PQ_CONCURRENT_UNION NO_PQ_CONCURRENT_UNION PQ_CONCURRENT_UNION QKSFM_PQ
PQ_DISTRIBUTE_WINDOW PQ_DISTRIBUTE_WINDOW QKSFM_PQ
PQ_FILTER PQ_FILTER QKSFM_PQ
NO_PQ_REPLICATE PQ_REPLICATE PQ_REPLICATE QKSFM_PQ_REPLICATE
PQ_REPLICATE NO_PQ_REPLICATE PQ_REPLICATE QKSFM_PQ_REPLICATE
NO_PQ_SKEW PQ_SKEW PQ_SKEW QKSFM_PQ
PQ_SKEW NO_PQ_SKEW PQ_SKEW QKSFM_PQ
NO_PX_FAULT_TOLERANCE PX_FAULT_TOLERANCE PX_FAULT_TOLERANCE QKSFM_PQ
PX_FAULT_TOLERANCE NO_PX_FAULT_TOLERANCE PX_FAULT_TOLERANCE QKSFM_PQ
CUBE_SJ SEMIJOIN QKSFM_JOIN_METHOD
USE_HIDDEN_PARTITIONS USE_HIDDEN_PARTITIONS QKSFM_PARTITION
WITH_PLSQL WITH_PLSQL QKSFM_ALL
NO_ZONEMAP ZONEMAP ZONEMAP QKSFM_ZONEMAP
ZONEMAP NO_ZONEMAP ZONEMAP QKSFM_ZONEMAP
********* ------------------------------
count 37
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.2.0.4 DISABLE_PARALLEL_DML ENABLE_PARALLEL_DML ENABLE_PARALLEL_DML QKSFM_DML
ENABLE_PARALLEL_DML DISABLE_PARALLEL_DML ENABLE_PARALLEL_DML QKSFM_DML
********* ------------------------------
count 2
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.2.0.3 FULL_OUTER_JOIN_TO_OUTER NO_FULL_OUTER_JOIN_TO_OUTER FULL_OUTER_JOIN_TO_OUTER QKSFM_CBO
NO_FULL_OUTER_JOIN_TO_OUTER FULL_OUTER_JOIN_TO_OUTER FULL_OUTER_JOIN_TO_OUTER QKSFM_CBO
NO_SEMI_TO_INNER SEMI_TO_INNER NO_SEMI_TO_INNER QKSFM_CBO
NO_OUTER_JOIN_TO_ANTI OUTER_JOIN_TO_ANTI OUTER_JOIN_TO_ANTI QKSFM_CBO
OUTER_JOIN_TO_ANTI NO_OUTER_JOIN_TO_ANTI OUTER_JOIN_TO_ANTI QKSFM_CBO
SEMI_TO_INNER NO_SEMI_TO_INNER SEMI_TO_INNER QKSFM_CBO
********* ------------------------------
count 6
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.2.0.2 NO_TABLE_LOOKUP_BY_NL TABLE_LOOKUP_BY_NL TABLE_LOOKUP_BY_NL QKSFM_TABLE_LOOKUP_BY_NL
TABLE_LOOKUP_BY_NL NO_TABLE_LOOKUP_BY_NL TABLE_LOOKUP_BY_NL QKSFM_TABLE_LOOKUP_BY_NL
NO_USE_HASH_GBY_FOR_PUSHDOWN USE_HASH_GBY_FOR_PUSHDOWN USE_HASH_GBY_FOR_PUSHDOWN QKSFM_ALL
USE_HASH_GBY_FOR_PUSHDOWN NO_USE_HASH_GBY_FOR_PUSHDOWN USE_HASH_GBY_FOR_PUSHDOWN QKSFM_ALL
NO_XDB_FASTPATH_INSERT XDB_FASTPATH_INSERT XDB_FASTPATH_INSERT QKSFM_ALL
XDB_FASTPATH_INSERT NO_XDB_FASTPATH_INSERT XDB_FASTPATH_INSERT QKSFM_ALL
********* ------------------------------
count 6
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.2.0.1 APPEND_VALUES NOAPPEND APPEND_VALUES QKSFM_CBO
COALESCE_SQ NO_COALESCE_SQ COALESCE_SQ QKSFM_COALESCE_SQ
NO_COALESCE_SQ COALESCE_SQ COALESCE_SQ QKSFM_COALESCE_SQ
CONNECT_BY_ELIM_DUPS NO_CONNECT_BY_ELIM_DUPS CONNECT_BY_ELIM_DUPS QKSFM_ALL
NO_CONNECT_BY_ELIM_DUPS CONNECT_BY_ELIM_DUPS CONNECT_BY_ELIM_DUPS QKSFM_ALL
DST_UPGRADE_INSERT_CONV NO_DST_UPGRADE_INSERT_CONV DST_UPGRADE_INSERT_CONV QKSFM_ALL
NO_DST_UPGRADE_INSERT_CONV DST_UPGRADE_INSERT_CONV DST_UPGRADE_INSERT_CONV QKSFM_ALL
EXPAND_TABLE NO_EXPAND_TABLE EXPAND_TABLE QKSFM_TABLE_EXPANSION
NO_EXPAND_TABLE EXPAND_TABLE EXPAND_TABLE QKSFM_TABLE_EXPANSION
FACTORIZE_JOIN NO_FACTORIZE_JOIN FACTORIZE_JOIN QKSFM_JOINFAC
NO_FACTORIZE_JOIN FACTORIZE_JOIN FACTORIZE_JOIN QKSFM_JOINFAC
NO_SUBSTRB_PAD NO_SUBSTRB_PAD QKSFM_EXECUTION
NO_PLACE_DISTINCT PLACE_DISTINCT PLACE_DISTINCT QKSFM_DIST_PLCMT
PLACE_DISTINCT NO_PLACE_DISTINCT PLACE_DISTINCT QKSFM_DIST_PLCMT
NO_STATEMENT_QUEUING STATEMENT_QUEUING STATEMENT_QUEUING QKSFM_PARALLEL
STATEMENT_QUEUING NO_STATEMENT_QUEUING STATEMENT_QUEUING QKSFM_PARALLEL
NO_TRANSFORM_DISTINCT_AGG TRANSFORM_DISTINCT_AGG TRANSFORM_DISTINCT_AGG QKSFM_TRANSFORMATION
TRANSFORM_DISTINCT_AGG NO_TRANSFORM_DISTINCT_AGG TRANSFORM_DISTINCT_AGG QKSFM_TRANSFORMATION
XMLINDEX_SEL_IDX_TBL XMLINDEX_SEL_IDX_TBL QKSFM_ALL
********* ------------------------------
count 19
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.1.0.7 BIND_AWARE NO_BIND_AWARE BIND_AWARE QKSFM_CURSOR_SHARING
NO_BIND_AWARE BIND_AWARE BIND_AWARE QKSFM_CURSOR_SHARING
CHANGE_DUPKEY_ERROR_INDEX CHANGE_DUPKEY_ERROR_INDEX QKSFM_DML
IGNORE_ROW_ON_DUPKEY_INDEX IGNORE_ROW_ON_DUPKEY_INDEX QKSFM_DML
RETRY_ON_ROW_CHANGE RETRY_ON_ROW_CHANGE QKSFM_DML
********* ------------------------------
count 5
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
11.1.0.6 INDEX_RS_ASC ACCESS QKSFM_INDEX_RS_ASC
INDEX_RS_DESC ACCESS QKSFM_INDEX_RS_DESC
NLJ_BATCHING NO_NLJ_BATCHING ACCESS QKSFM_EXECUTION
NLJ_PREFETCH NO_NLJ_PREFETCH ACCESS QKSFM_EXECUTION
NO_NLJ_BATCHING NLJ_BATCHING ACCESS QKSFM_EXECUTION
NO_NLJ_PREFETCH NLJ_PREFETCH ACCESS QKSFM_EXECUTION
CHECK_ACL_REWRITE NO_CHECK_ACL_REWRITE CHECK_ACL_REWRITE QKSFM_CHECK_ACL_REWRITE
COST_XML_QUERY_REWRITE NO_COST_XML_QUERY_REWRITE COST_XML_QUERY_REWRITE QKSFM_COST_XML_QUERY_REWRITE
DB_VERSION DB_VERSION QKSFM_ALL
DOMAIN_INDEX_FILTER NO_DOMAIN_INDEX_FILTER DOMAIN_INDEX_FILTER QKSFM_CBO
USE_MERGE_CARTESIAN JOIN QKSFM_USE_MERGE_CARTESIAN
MONITOR NO_MONITOR MONITOR QKSFM_ALL
NO_MONITOR MONITOR MONITOR QKSFM_ALL
NO_CHECK_ACL_REWRITE CHECK_ACL_REWRITE NO_CHECK_ACL_REWRITE QKSFM_CHECK_ACL_REWRITE
NO_COST_XML_QUERY_REWRITE COST_XML_QUERY_REWRITE NO_COST_XML_QUERY_REWRITE QKSFM_COST_XML_QUERY_REWRITE
NO_DOMAIN_INDEX_FILTER DOMAIN_INDEX_FILTER NO_DOMAIN_INDEX_FILTER QKSFM_CBO
NO_LOAD NO_LOAD QKSFM_EXECUTION
NO_OUTER_JOIN_TO_INNER OUTER_JOIN_TO_INNER OUTER_JOIN_TO_INNER QKSFM_OUTER_JOIN_TO_INNER
OUTER_JOIN_TO_INNER NO_OUTER_JOIN_TO_INNER OUTER_JOIN_TO_INNER QKSFM_OUTER_JOIN_TO_INNER
NO_PLACE_GROUP_BY PLACE_GROUP_BY PLACE_GROUP_BY QKSFM_PLACE_GROUP_BY
PLACE_GROUP_BY NO_PLACE_GROUP_BY PLACE_GROUP_BY QKSFM_PLACE_GROUP_BY
NO_RESULT_CACHE RESULT_CACHE RESULT_CACHE QKSFM_EXECUTION
RESULT_CACHE NO_RESULT_CACHE RESULT_CACHE QKSFM_EXECUTION
NO_SUBQUERY_PRUNING SUBQUERY_PRUNING SUBQUERY_PRUNING QKSFM_CBO
SUBQUERY_PRUNING NO_SUBQUERY_PRUNING SUBQUERY_PRUNING QKSFM_CBO
NO_USE_INVISIBLE_INDEXES USE_INVISIBLE_INDEXES USE_INVISIBLE_INDEXES QKSFM_INDEX
USE_INVISIBLE_INDEXES NO_USE_INVISIBLE_INDEXES USE_INVISIBLE_INDEXES QKSFM_INDEX
NO_XMLINDEX_REWRITE XMLINDEX_REWRITE XMLINDEX_REWRITE QKSFM_XMLINDEX_REWRITE
NO_XMLINDEX_REWRITE_IN_SELECT XMLINDEX_REWRITE_IN_SELECT XMLINDEX_REWRITE QKSFM_XMLINDEX_REWRITE
XMLINDEX_REWRITE NO_XMLINDEX_REWRITE XMLINDEX_REWRITE QKSFM_XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT NO_XMLINDEX_REWRITE_IN_SELECT XMLINDEX_REWRITE QKSFM_XMLINDEX_REWRITE
XML_DML_RWT_STMT XML_DML_RWT_STMT QKSFM_XML_REWRITE
********* ------------------------------
count 32
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.2.0.5 CONNECT_BY_CB_WHR_ONLY NO_CONNECT_BY_CB_WHR_ONLY CONNECT_BY_CB_WHR_ONLY QKSFM_TRANSFORMATION
NO_CONNECT_BY_CB_WHR_ONLY CONNECT_BY_CB_WHR_ONLY CONNECT_BY_CB_WHR_ONLY QKSFM_TRANSFORMATION
GBY_PUSHDOWN NO_GBY_PUSHDOWN GBY_PUSHDOWN QKSFM_ALL
NO_GBY_PUSHDOWN GBY_PUSHDOWN GBY_PUSHDOWN QKSFM_ALL
********* ------------------------------
count 4
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.2.0.4 CONNECT_BY_COMBINE_SW NO_CONNECT_BY_COMBINE_SW CONNECT_BY_COMBINE_SW QKSFM_ALL
NO_CONNECT_BY_COMBINE_SW CONNECT_BY_COMBINE_SW CONNECT_BY_COMBINE_SW QKSFM_ALL
********* ------------------------------
count 2
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.2.0.3 NUM_INDEX_KEYS ACCESS QKSFM_CBO
NATIVE_FULL_OUTER_JOIN NO_NATIVE_FULL_OUTER_JOIN NATIVE_FULL_OUTER_JOIN QKSFM_ALL
NO_NATIVE_FULL_OUTER_JOIN NATIVE_FULL_OUTER_JOIN NATIVE_FULL_OUTER_JOIN QKSFM_ALL
********* ------------------------------
count 3
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.2.0.2 CONNECT_BY_COST_BASED NO_CONNECT_BY_COST_BASED CONNECT_BY_COST_BASED QKSFM_TRANSFORMATION
NO_CONNECT_BY_COST_BASED CONNECT_BY_COST_BASED CONNECT_BY_COST_BASED QKSFM_TRANSFORMATION
CONNECT_BY_FILTERING NO_CONNECT_BY_FILTERING CONNECT_BY_FILTERING QKSFM_ALL
NO_CONNECT_BY_FILTERING CONNECT_BY_FILTERING CONNECT_BY_FILTERING QKSFM_ALL
********* ------------------------------
count 4
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.2.0.1 BITMAP_TREE ACCESS QKSFM_BITMAP_TREE
DBMS_STATS DBMS_STATS QKSFM_DBMS_STATS
ELIMINATE_JOIN NO_ELIMINATE_JOIN ELIMINATE_JOIN QKSFM_TABLE_ELIM
NO_ELIMINATE_JOIN ELIMINATE_JOIN ELIMINATE_JOIN QKSFM_TABLE_ELIM
ELIMINATE_OBY NO_ELIMINATE_OBY ELIMINATE_OBY QKSFM_OBYE
NO_ELIMINATE_OBY ELIMINATE_OBY ELIMINATE_OBY QKSFM_OBYE
INLINE_XMLTYPE_NT INLINE_XMLTYPE_NT QKSFM_ALL
MODEL_COMPILE_SUBQUERY MODEL_COMPILE_SUBQUERY QKSFM_TRANSFORMATION
MODEL_DYNAMIC_SUBQUERY MODEL_DYNAMIC_SUBQUERY QKSFM_TRANSFORMATION
NO_CARTESIAN NO_CARTESIAN QKSFM_ALL
NO_SQL_TUNE NO_SQL_TUNE QKSFM_ALL
NO_XML_DML_REWRITE NO_XML_DML_REWRITE QKSFM_XML_REWRITE
OLD_PUSH_PRED OLD_PUSH_PRED QKSFM_OLD_PUSH_PRED
OPT_PARAM OPT_PARAM QKSFM_ALL
OUTLINE OUTLINE QKSFM_ALL
OUTLINE_LEAF OUTLINE_LEAF QKSFM_ALL
PRECOMPUTE_SUBQUERY PRECOMPUTE_SUBQUERY QKSFM_TRANSFORMATION
PRESERVE_OID PRESERVE_OID QKSFM_ALL
NO_PULL_PRED PULL_PRED PULL_PRED QKSFM_PULL_PRED
PULL_PRED NO_PULL_PRED PULL_PRED QKSFM_PULL_PRED
NO_PX_JOIN_FILTER PX_JOIN_FILTER PX_JOIN_FILTER QKSFM_PX_JOIN_FILTER
PX_JOIN_FILTER NO_PX_JOIN_FILTER PX_JOIN_FILTER QKSFM_PX_JOIN_FILTER
RBO_OUTLINE RBO_OUTLINE QKSFM_RBO
NO_USE_HASH_AGGREGATION USE_HASH_AGGREGATION USE_HASH_AGGREGATION QKSFM_ALL
USE_HASH_AGGREGATION NO_USE_HASH_AGGREGATION USE_HASH_AGGREGATION QKSFM_ALL
********* ------------------------------
count 25
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
10.1.0.3 FBTSCAN FBTSCAN QKSFM_CBO
GATHER_PLAN_STATISTICS GATHER_PLAN_STATISTICS QKSFM_GATHER_PLAN_STATISTICS
IGNORE_OPTIM_EMBEDDED_HINTS IGNORE_OPTIM_EMBEDDED_HINTS QKSFM_ALL
INCLUDE_VERSION INCLUDE_VERSION QKSFM_ALL
MODEL_DONTVERIFY_UNIQUENESS MODEL_DONTVERIFY_UNIQUENESS QKSFM_TRANSFORMATION
MODEL_MIN_ANALYSIS MODEL_MIN_ANALYSIS QKSFM_TRANSFORMATION
MODEL_NO_ANALYSIS MODEL_MIN_ANALYSIS QKSFM_ALL
MODEL_PUSH_REF NO_MODEL_PUSH_REF MODEL_PUSH_REF QKSFM_TRANSFORMATION
NO_MODEL_PUSH_REF MODEL_PUSH_REF MODEL_PUSH_REF QKSFM_ALL
NESTED_TABLE_FAST_INSERT NESTED_TABLE_FAST_INSERT QKSFM_ALL
NO_INDEX_FFS INDEX_FFS NO_INDEX_FFS QKSFM_INDEX_FFS
NO_INDEX_SS INDEX_SS NO_INDEX_SS QKSFM_INDEX_SS
NO_PARTIAL_COMMIT NO_PARTIAL_COMMIT QKSFM_CBO
NO_QUERY_TRANSFORMATION NO_QUERY_TRANSFORMATION QKSFM_TRANSFORMATION
NO_USE_HASH USE_HASH NO_USE_HASH QKSFM_USE_HASH
NO_USE_MERGE USE_MERGE NO_USE_MERGE QKSFM_USE_MERGE
NO_USE_NL USE_NL NO_USE_NL QKSFM_USE_NL
OPAQUE_TRANSFORM OPAQUE_TRANSFORM QKSFM_TRANSFORMATION
OPAQUE_XCANONICAL OPAQUE_XCANONICAL QKSFM_TRANSFORMATION
OPTIMIZER_FEATURES_ENABLE OPTIMIZER_FEATURES_ENABLE QKSFM_ALL
OPT_ESTIMATE OPT_ESTIMATE QKSFM_OPT_ESTIMATE
QB_NAME QB_NAME QKSFM_ALL
RESTRICT_ALL_REF_CONS RESTRICT_ALL_REF_CONS QKSFM_ALL
NO_BASETABLE_MULTIMV_REWRITE REWRITE REWRITE QKSFM_ALL
NO_MULTIMV_REWRITE REWRITE REWRITE QKSFM_ALL
REWRITE_OR_ERROR REWRITE QKSFM_TRANSFORMATION
NO_SET_TO_JOIN SET_TO_JOIN SET_TO_JOIN QKSFM_SET_TO_JOIN
SET_TO_JOIN NO_SET_TO_JOIN SET_TO_JOIN QKSFM_SET_TO_JOIN
NO_PARALLEL SHARED SHARED QKSFM_CBO
SKIP_UNQ_UNUSABLE_IDX SKIP_UNQ_UNUSABLE_IDX QKSFM_CBO
NO_STAR_TRANSFORMATION STAR_TRANSFORMATION STAR_TRANSFORMATION QKSFM_STAR_TRANS
STREAMS STREAMS QKSFM_CBO
NO_SWAP_JOIN_INPUTS SWAP_JOIN_INPUTS SWAP_JOIN_INPUTS QKSFM_CBO
COLUMN_STATS TABLE_STATS QKSFM_STATS
INDEX_STATS TABLE_STATS QKSFM_STATS
TABLE_STATS TABLE_STATS QKSFM_STATS
TRACING TRACING QKSFM_EXECUTION
USE_NL_WITH_INDEX NO_USE_NL USE_NL_WITH_INDEX QKSFM_USE_NL_WITH_INDEX
USE_WEAK_NAME_RESL USE_WEAK_NAME_RESL QKSFM_ALL
VECTOR_READ VECTOR_READ QKSFM_CBO
VECTOR_READ_TRACE VECTOR_READ_TRACE QKSFM_CBO
X_DYN_PRUNE X_DYN_PRUNE QKSFM_CBO
********* ------------------------------
count 42
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
9.2.0 DYNAMIC_SAMPLING DYNAMIC_SAMPLING QKSFM_DYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN DYNAMIC_SAMPLING_EST_CDN QKSFM_DYNAMIC_SAMPLING_EST_CDN
EXPAND_GSET_TO_UNION NO_EXPAND_GSET_TO_UNION EXPAND_GSET_TO_UNION QKSFM_TRANSFORMATION
NO_EXPAND_GSET_TO_UNION EXPAND_GSET_TO_UNION EXPAND_GSET_TO_UNION QKSFM_TRANSFORMATION
FORCE_XML_QUERY_REWRITE NO_XML_QUERY_REWRITE FORCE_XML_QUERY_REWRITE QKSFM_XML_REWRITE
NO_XML_QUERY_REWRITE FORCE_XML_QUERY_REWRITE FORCE_XML_QUERY_REWRITE QKSFM_XML_REWRITE
IGNORE_WHERE_CLAUSE IGNORE_WHERE_CLAUSE QKSFM_ALL
NO_QKN_BUFF NO_QKN_BUFF QKSFM_CBO
NO_PUSH_SUBQ PUSH_SUBQ PUSH_SUBQ QKSFM_TRANSFORMATION
NO_REF_CASCADE REF_CASCADE_CURSOR REF_CASCADE_CURSOR QKSFM_CBO
REF_CASCADE_CURSOR NO_REF_CASCADE REF_CASCADE_CURSOR QKSFM_CBO
SYS_DL_CURSOR SYS_DL_CURSOR QKSFM_CBO
SYS_RID_ORDER SYS_RID_ORDER QKSFM_ALL
********* ------------------------------
count 13
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
9.0.0 INDEX_RRS ACCESS QKSFM_CBO
INDEX_SS NO_INDEX_SS ACCESS QKSFM_INDEX_SS
INDEX_SS_ASC NO_INDEX_SS ACCESS QKSFM_INDEX_SS_ASC
INDEX_SS_DESC NO_INDEX_SS ACCESS QKSFM_INDEX_SS_DESC
ANTIJOIN ANTIJOIN QKSFM_TRANSFORMATION
BYPASS_RECURSIVE_CHECK BYPASS_RECURSIVE_CHECK QKSFM_ALL
CARDINALITY CARDINALITY QKSFM_STATS
CPU_COSTING NO_CPU_COSTING CPU_COSTING QKSFM_CPU_COSTING
NO_CPU_COSTING CPU_COSTING CPU_COSTING QKSFM_CPU_COSTING
CURSOR_SHARING_EXACT CURSOR_SHARING_EXACT QKSFM_CBO
DML_UPDATE DML_UPDATE QKSFM_CBO
GBY_CONC_ROLLUP GBY_CONC_ROLLUP QKSFM_TRANSFORMATION
HWM_BROKERED HWM_BROKERED QKSFM_CBO
INLINE MATERIALIZE INLINE QKSFM_TRANSFORMATION
MATERIALIZE INLINE INLINE QKSFM_TRANSFORMATION
LOCAL_INDEXES LOCAL_INDEXES QKSFM_CBO
MV_MERGE MV_MERGE QKSFM_TRANSFORMATION
NO_PRUNE_GSETS NO_PRUNE_GSETS QKSFM_TRANSFORMATION
OVERFLOW_NOMOVE OVERFLOW_NOMOVE QKSFM_CBO
PQ_MAP PQ_NOMAP PQ_MAP QKSFM_PQ_MAP
PQ_NOMAP PQ_MAP PQ_MAP QKSFM_PQ_MAP
NO_SEMIJOIN SEMIJOIN SEMIJOIN QKSFM_TRANSFORMATION
SEMIJOIN NO_SEMIJOIN SEMIJOIN QKSFM_TRANSFORMATION
SKIP_EXT_OPTIMIZER SKIP_EXT_OPTIMIZER QKSFM_CBO
SQLLDR SQLLDR QKSFM_CBO
USE_TTT_FOR_GSETS USE_TTT_FOR_GSETS QKSFM_TRANSFORMATION
********* ------------------------------
count 26
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
8.1.6 LEADING LEADING QKSFM_JOIN_ORDER
SYS_PARALLEL_TXN SYS_PARALLEL_TXN QKSFM_CBO
NO_UNNEST UNNEST UNNEST QKSFM_UNNEST
UNNEST NO_UNNEST UNNEST QKSFM_UNNEST
********* ------------------------------
count 4
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
8.1.5 INDEX_JOIN ACCESS QKSFM_INDEX_JOIN
BUFFER NO_BUFFER BUFFER QKSFM_CBO
NO_BUFFER BUFFER BUFFER QKSFM_CBO
BYPASS_UJVC BYPASS_UJVC QKSFM_CBO
CACHE_CB NOCACHE CACHE_CB QKSFM_CBO
CUBE_GB CUBE_GB QKSFM_CBO
DOMAIN_INDEX_NO_SORT DOMAIN_INDEX_SORT DOMAIN_INDEX_SORT QKSFM_CBO
DOMAIN_INDEX_SORT DOMAIN_INDEX_NO_SORT DOMAIN_INDEX_SORT QKSFM_CBO
NESTED_TABLE_SET_SETID NESTED_TABLE_SET_SETID QKSFM_ALL
NO_ACCESS NO_ACCESS QKSFM_ALL
NO_INDEX INDEX NO_INDEX QKSFM_INDEX
PQ_DISTRIBUTE PQ_DISTRIBUTE QKSFM_PQ_DISTRIBUTE
RESTORE_AS_INTERVALS RESTORE_AS_INTERVALS QKSFM_CBO
NO_REWRITE REWRITE REWRITE QKSFM_TRANSFORMATION
REWRITE NO_REWRITE REWRITE QKSFM_TRANSFORMATION
SAVE_AS_INTERVALS SAVE_AS_INTERVALS QKSFM_CBO
SCN_ASCENDING SCN_ASCENDING QKSFM_ALL
********* ------------------------------
count 17
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
8.1.0 AND_EQUAL ACCESS QKSFM_AND_EQUAL
FULL ACCESS QKSFM_FULL
HASH ACCESS QKSFM_ALL
INDEX_ASC NO_INDEX ACCESS QKSFM_INDEX_ASC
INDEX_COMBINE ACCESS QKSFM_INDEX_COMBINE
INDEX_DESC NO_INDEX ACCESS QKSFM_INDEX_DESC
INDEX_FFS ACCESS QKSFM_INDEX_FFS
HASH_AJ ANTIJOIN QKSFM_JOIN_METHOD
MERGE_AJ ANTIJOIN QKSFM_JOIN_METHOD
APPEND NOAPPEND APPEND QKSFM_CBO
NOAPPEND APPEND APPEND QKSFM_CBO
BITMAP BITMAP QKSFM_CBO
CACHE NOCACHE CACHE QKSFM_EXECUTION
NOCACHE CACHE CACHE QKSFM_EXECUTION
DEREF_NO_REWRITE DEREF_NO_REWRITE QKSFM_ALL
DRIVING_SITE DRIVING_SITE QKSFM_ALL
FACT NO_FACT FACT QKSFM_STAR_TRANS
NO_FACT FACT FACT QKSFM_STAR_TRANS
USE_HASH NO_USE_HASH JOIN QKSFM_USE_HASH
USE_MERGE NO_USE_MERGE JOIN QKSFM_USE_MERGE
USE_NL NO_USE_NL JOIN QKSFM_USE_NL
MERGE NO_MERGE MERGE QKSFM_CVM
ALL_ROWS MODE QKSFM_ALL_ROWS
CHOOSE MODE QKSFM_CHOOSE
FIRST_ROWS MODE QKSFM_FIRST_ROWS
RULE MODE QKSFM_RBO
NESTED_TABLE_GET_REFS NESTED_TABLE_GET_REFS QKSFM_ALL
ORDERED ORDERED QKSFM_CBO
NO_EXPAND USE_CONCAT OR_EXPAND QKSFM_USE_CONCAT
USE_CONCAT NO_EXPAND OR_EXPAND QKSFM_USE_CONCAT
NO_PARALLEL_INDEX PARALLEL_INDEX PARALLEL_INDEX QKSFM_PQ
PARALLEL_INDEX NO_PARALLEL_INDEX PARALLEL_INDEX QKSFM_PQ
PIV_GB PIV_GB QKSFM_ALL
TIV_GB PIV_GB QKSFM_ALL
PIV_SSF PIV_SSF QKSFM_ALL
TIV_SSF PIV_SSF QKSFM_ALL
NO_PUSH_PRED PUSH_PRED PUSH_PRED QKSFM_FILTER_PUSH_PRED
PUSH_PRED NO_PUSH_PRED PUSH_PRED QKSFM_FILTER_PUSH_PRED
PUSH_SUBQ NO_PUSH_SUBQ PUSH_SUBQ QKSFM_TRANSFORMATION
REMOTE_MAPPED REMOTE_MAPPED QKSFM_ALL
HASH_SJ SEMIJOIN QKSFM_JOIN_METHOD
MERGE_SJ SEMIJOIN QKSFM_JOIN_METHOD
SEMIJOIN_DRIVER SEMIJOIN_DRIVER QKSFM_CBO
NOPARALLEL SHARED SHARED QKSFM_PARALLEL
SHARED NO_PARALLEL SHARED QKSFM_PARALLEL
STAR STAR QKSFM_STAR_TRANS
STAR_TRANSFORMATION NO_STAR_TRANSFORMATION STAR_TRANSFORMATION QKSFM_STAR_TRANS
SWAP_JOIN_INPUTS NO_SWAP_JOIN_INPUTS SWAP_JOIN_INPUTS QKSFM_CBO
USE_ANTI USE_ANTI QKSFM_CBO
USE_SEMI USE_SEMI QKSFM_CBO
********* ------------------------------
count 50
VERSION HINT_NAME INVERSE CLASS SQL_FEATURE
--------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
8.0.0 CLUSTER ACCESS QKSFM_CBO
INDEX NO_INDEX ACCESS QKSFM_INDEX
QUEUE_CURR ACCESS QKSFM_CBO
QUEUE_ROWP ACCESS QKSFM_CBO
ROWID ACCESS QKSFM_CBO
NL_AJ ANTIJOIN QKSFM_JOIN_METHOD
EXPR_CORR_CHECK EXPR_CORR_CHECK QKSFM_CBO
NO_MERGE MERGE MERGE QKSFM_CVM
MERGE_CONST_ON MERGE_CONST_ON QKSFM_CBO
NO_MONITORING NO_MONITORING QKSFM_ALL
NO_ORDER_ROLLUPS NO_ORDER_ROLLUPS QKSFM_TRANSFORMATION
NO_STATS_GSETS NO_STATS_GSETS QKSFM_ALL
ORDERED_PREDICATES ORDERED_PREDICATES QKSFM_CBO
NL_SJ SEMIJOIN QKSFM_JOIN_METHOD
********* ------------------------------
count 14
352行が選択されました。