オンプレミス版Oracle12c R2リリース！
OTNでOracle12c R2がダウンロード出来るようになったので早速手元環境にインストールしてみた。
1 2 3 4 5 6 7 8 9 | SQL> select BANNER from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionPL/SQL Release 12.2.0.1.0 - ProductionCORE 12.2.0.1.0 ProductionTNS for Linux: Version 12.2.0.1.0 - ProductionNLSRTL Version 12.2.0.1.0 - Production |
新しく追加されたヒント句を確認する
以前12cR1までのヒント句の変遷を追ってみたことがある。Oracleバージョンによるヒント句の変遷 参照
今回のバージョンアップで新たに追加されたヒント句を確認してみよう。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | 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までのヒント句を以下に再掲する。（バージョンの降順）
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 | 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 19VERSION 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 37VERSION 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 2VERSION 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 6VERSION 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 6VERSION 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 19VERSION 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 5VERSION 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 32VERSION 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 4VERSION 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 2VERSION 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 3VERSION 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 4VERSION 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 25VERSION 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 42VERSION 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 13VERSION 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 26VERSION 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 4VERSION 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 17VERSION 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 50VERSION 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 14352行が選択されました。 |