In Oracle 11.1 and above, a new dynamic performance view describes all supported hints together with information about the features they support, their inverse operation and the version in which they first appear.
In Oracle 11.1.0.7 there are 239 hints; in Oracle 11.2.0.1 there are 263 hints
The underlying fixed table is X$QKSHT which also contains the same number of rows as V$SQL_HINT. Therefore there is no concept of "hidden" hints in the same way that there are unsupported parameters for example
The following table summarizes the hints listed in Oracle 11.2.0.1:
| Name | Version | SQL Feature | Class | Inverse |
| ALL_ROWS | 8.1.0 | QKSFM_ALL_ROWS | MODE | |
| AND_EQUAL | 8.1.0 | QKSFM_AND_EQUAL | ACCESS | |
| ANTIJOIN | 9.0.0 | QKSFM_TRANSFORMATION | ANTIJOIN | |
| APPEND | 8.1.0 | QKSFM_CBO | APPEND | NOAPPEND |
| APPEND_VALUES | 11.2.0.1 | QKSFM_CBO | APPEND_VALUES | NOAPPEND |
| BIND_AWARE | 11.1.0.7 | QKSFM_CURSOR_SHARING | BIND_AWARE | NO_BIND_AWARE |
| BITMAP | 8.1.0 | QKSFM_CBO | BITMAP | |
| BITMAP_TREE | 10.2.0.1 | QKSFM_BITMAP_TREE | ACCESS | |
| BUFFER | 8.1.5 | QKSFM_CBO | BUFFER | NO_BUFFER |
| BYPASS_RECURSIVE_CHECK | 9.0.0 | QKSFM_ALL | BYPASS_RECURSIVE_CHECK | |
| BYPASS_UJVC | 8.1.5 | QKSFM_CBO | BYPASS_UJVC | |
| CACHE | 8.1.0 | QKSFM_EXECUTION | CACHE | NOCACHE |
| CACHE_CB | 8.1.5 | QKSFM_CBO | CACHE_CB | NOCACHE |
| CACHE_TEMP_TABLE | 8.1.5 | QKSFM_ALL | CACHE | NOCACHE |
| CARDINALITY | 9.0.0 | QKSFM_STATS | CARDINALITY | |
| CHANGE_DUPKEY_ERROR_INDEX | 11.1.0.7 | QKSFM_DML | CHANGE_DUPKEY_ERROR_INDEX | |
| CHECK_ACL_REWRITE | 11.1.0.6 | QKSFM_CHECK_ACL_REWRITE | CHECK_ACL_REWRITE | NO_CHECK_ACL_REWRITE |
| CHOOSE | 8.1.0 | QKSFM_CHOOSE | MODE | |
| CLUSTER | 8.0.0 | QKSFM_CBO | ACCESS | |
| COALESCE_SQ | 11.2.0.1 | QKSFM_COALESCE_SQ | COALESCE_SQ | NO_COALESCE_SQ |
| COLUMN_STATS | 10.1.0.3 | QKSFM_STATS | TABLE_STATS | |
| CONNECT_BY_CB_WHR_ONLY | 10.2.0.5 | QKSFM_TRANSFORMATION | CONNECT_BY_CB_WHR_ONLY | NO_CONNECT_BY_CB_WHR_ONLY |
| CONNECT_BY_COMBINE_SW | 10.2.0.4 | QKSFM_ALL | CONNECT_BY_COMBINE_SW | NO_CONNECT_BY_COMBINE_SW |
| CONNECT_BY_COST_BASED | 10.2.0.2 | QKSFM_TRANSFORMATION | CONNECT_BY_COST_BASED | NO_CONNECT_BY_COST_BASED |
| CONNECT_BY_ELIM_DUPS | 11.2.0.1 | QKSFM_ALL | CONNECT_BY_ELIM_DUPS | NO_CONNECT_BY_ELIM_DUPS |
| CONNECT_BY_FILTERING | 10.2.0.2 | QKSFM_ALL | CONNECT_BY_FILTERING | NO_CONNECT_BY_FILTERING |
| COST_XML_QUERY_REWRITE | 11.1.0.6 | QKSFM_COST_XML_QUERY_REWRITE | COST_XML_QUERY_REWRITE | NO_COST_XML_QUERY_REWRITE |
| CPU_COSTING | 9.0.0 | QKSFM_CPU_COSTING | CPU_COSTING | NO_CPU_COSTING |
| CUBE_GB | 8.1.5 | QKSFM_CBO | CUBE_GB | |
| CURSOR_SHARING_EXACT | 9.0.0 | QKSFM_CBO | CURSOR_SHARING_EXACT | |
| DBMS_STATS | 10.2.0.1 | QKSFM_DBMS_STATS | DBMS_STATS | |
| DB_VERSION | 11.1.0.6 | QKSFM_ALL | DB_VERSION | |
| DEREF_NO_REWRITE | 8.1.0 | QKSFM_ALL | DEREF_NO_REWRITE | |
| DML_UPDATE | 9.0.0 | QKSFM_CBO | DML_UPDATE | |
| DOMAIN_INDEX_FILTER | 11.1.0.6 | QKSFM_CBO | DOMAIN_INDEX_FILTER | NO_DOMAIN_INDEX_FILTER |
| DOMAIN_INDEX_NO_SORT | 8.1.5 | QKSFM_CBO | DOMAIN_INDEX_SORT | DOMAIN_INDEX_SORT |
| DOMAIN_INDEX_SORT | 8.1.5 | QKSFM_CBO | DOMAIN_INDEX_SORT | DOMAIN_INDEX_NO_SORT |
| DRIVING_SITE | 8.1.0 | QKSFM_ALL | DRIVING_SITE | |
| DST_UPGRADE_INSERT_CONV | 11.2.0.1 | QKSFM_ALL | DST_UPGRADE_INSERT_CONV | NO_DST_UPGRADE_INSERT_CONV |
| DYNAMIC_SAMPLING | 9.2.0 | QKSFM_DYNAMIC_SAMPLING | DYNAMIC_SAMPLING | |
| DYNAMIC_SAMPLING_EST_CDN | 9.2.0 | QKSFM_DYNAMIC_SAMPLING_EST_CDN | DYNAMIC_SAMPLING_EST_CDN | |
| ELIMINATE_JOIN | 10.2.0.1 | QKSFM_TABLE_ELIM | ELIMINATE_JOIN | NO_ELIMINATE_JOIN |
| ELIMINATE_OBY | 10.2.0.1 | QKSFM_OBYE | ELIMINATE_OBY | NO_ELIMINATE_OBY |
| EXPAND_GSET_TO_UNION | 9.2.0 | QKSFM_TRANSFORMATION | EXPAND_GSET_TO_UNION | NO_EXPAND_GSET_TO_UNION |
| EXPAND_TABLE | 11.2.0.1 | QKSFM_TABLE_EXPANSION | EXPAND_TABLE | NO_EXPAND_TABLE |
| EXPR_CORR_CHECK | 8.0.0 | QKSFM_CBO | EXPR_CORR_CHECK | |
| FACT | 8.1.0 | QKSFM_STAR_TRANS | FACT | NO_FACT |
| FACTORIZE_JOIN | 11.2.0.1 | QKSFM_JOINFAC | FACTORIZE_JOIN | NO_FACTORIZE_JOIN |
| FBTSCAN | 10.1.0.3 | QKSFM_CBO | FBTSCAN | |
| FIRST_ROWS | 8.1.0 | QKSFM_FIRST_ROWS | MODE | |
| FORCE_XML_QUERY_REWRITE | 9.2.0 | QKSFM_XML_REWRITE | FORCE_XML_QUERY_REWRITE | NO_XML_QUERY_REWRITE |
| FULL | 8.1.0 | QKSFM_FULL | ACCESS | |
| GATHER_PLAN_STATISTICS | 10.1.0.3 | QKSFM_GATHER_PLAN_STATISTICS | GATHER_PLAN_STATISTICS | |
| GBY_CONC_ROLLUP | 9.0.0 | QKSFM_TRANSFORMATION | GBY_CONC_ROLLUP | |
| GBY_PUSHDOWN | 11.1.0.6 | QKSFM_ALL | GBY_PUSHDOWN | NO_GBY_PUSHDOWN |
| HASH | 8.1.0 | QKSFM_ALL | ACCESS | |
| HASH_AJ | 8.1.0 | QKSFM_CBO | ANTIJOIN | |
| HASH_SJ | 8.1.0 | QKSFM_CBO | SEMIJOIN | |
| HWM_BROKERED | 9.0.0 | QKSFM_CBO | HWM_BROKERED | |
| IGNORE_OPTIM_EMBEDDED_HINTS | 10.1.0.3 | QKSFM_ALL | IGNORE_OPTIM_EMBEDDED_HINTS | |
| IGNORE_ROW_ON_DUPKEY_INDEX | 11.1.0.7 | QKSFM_DML | IGNORE_ROW_ON_DUPKEY_INDEX | |
| IGNORE_WHERE_CLAUSE | 9.2.0 | QKSFM_ALL | IGNORE_WHERE_CLAUSE | |
| INCLUDE_VERSION | 10.1.0.3 | QKSFM_ALL | INCLUDE_VERSION | |
| INDEX | 8.0.0 | QKSFM_INDEX | ACCESS | NO_INDEX |
| INDEX_ASC | 8.1.0 | QKSFM_INDEX_ASC | ACCESS | NO_INDEX |
| INDEX_COMBINE | 8.1.0 | QKSFM_INDEX_COMBINE | ACCESS | |
| INDEX_DESC | 8.1.0 | QKSFM_INDEX_DESC | ACCESS | NO_INDEX |
| INDEX_FFS | 8.1.0 | QKSFM_INDEX_FFS | ACCESS | |
| INDEX_JOIN | 8.1.5 | QKSFM_INDEX_JOIN | ACCESS | |
| INDEX_RRS | 9.0.0 | QKSFM_CBO | ACCESS | |
| INDEX_RS_ASC | 11.1.0.6 | QKSFM_INDEX_RS_ASC | ACCESS | |
| INDEX_RS_DESC | 11.1.0.6 | QKSFM_INDEX_RS_DESC | ACCESS | |
| INDEX_SS | 9.0.0 | QKSFM_INDEX_SS | ACCESS | NO_INDEX_SS |
| INDEX_SS_ASC | 9.0.0 | QKSFM_INDEX_SS_ASC | ACCESS | NO_INDEX_SS |
| INDEX_SS_DESC | 9.0.0 | QKSFM_INDEX_SS_DESC | ACCESS | NO_INDEX_SS |
| INDEX_STATS | 10.1.0.3 | QKSFM_STATS | TABLE_STATS | |
| INLINE | 9.0.0 | QKSFM_TRANSFORMATION | INLINE | MATERIALIZE |
| INLINE_XMLTYPE_NT | 10.2.0.1 | QKSFM_ALL | INLINE_XMLTYPE_NT | |
| LEADING | 8.1.6 | QKSFM_JOIN_ORDER | LEADING | |
| LIKE_EXPAND | 8.1.7 | QKSFM_TRANSFORMATION | LIKE_EXPAND | |
| LOCAL_INDEXES | 9.0.0 | QKSFM_CBO | LOCAL_INDEXES | |
| MATERIALIZE | 9.0.0 | QKSFM_TRANSFORMATION | INLINE | INLINE |
| MERGE | 8.1.0 | QKSFM_CVM | MERGE | NO_MERGE |
| MERGE_AJ | 8.1.0 | QKSFM_CBO | ANTIJOIN | |
| MERGE_CONST_ON | 8.0.0 | QKSFM_CBO | MERGE_CONST_ON | |
| MERGE_SJ | 8.1.0 | QKSFM_CBO | SEMIJOIN | |
| MODEL_COMPILE_SUBQUERY | 10.2.0.1 | QKSFM_TRANSFORMATION | MODEL_COMPILE_SUBQUERY | |
| MODEL_DONTVERIFY_UNIQUENESS | 10.1.0.3 | QKSFM_TRANSFORMATION | MODEL_DONTVERIFY_UNIQUENESS | |
| MODEL_DYNAMIC_SUBQUERY | 10.2.0.1 | QKSFM_TRANSFORMATION | MODEL_DYNAMIC_SUBQUERY | |
| MODEL_MIN_ANALYSIS | 10.1.0.3 | QKSFM_TRANSFORMATION | MODEL_MIN_ANALYSIS | |
| MODEL_NO_ANALYSIS | 10.1.0.3 | QKSFM_ALL | MODEL_MIN_ANALYSIS | |
| MODEL_PUSH_REF | 10.1.0.3 | QKSFM_TRANSFORMATION | MODEL_PUSH_REF | NO_MODEL_PUSH_REF |
| MONITOR | 11.1.0.6 | QKSFM_ALL | MONITOR | NO_MONITOR |
| MV_MERGE | 9.0.0 | QKSFM_TRANSFORMATION | MV_MERGE | |
| NATIVE_FULL_OUTER_JOIN | 10.2.0.3 | QKSFM_ALL | NATIVE_FULL_OUTER_JOIN | NO_NATIVE_FULL_OUTER_JOIN |
| NESTED_TABLE_FAST_INSERT | 10.1.0.3 | QKSFM_ALL | NESTED_TABLE_FAST_INSERT | |
| NESTED_TABLE_GET_REFS | 8.1.0 | QKSFM_ALL | NESTED_TABLE_GET_REFS | |
| NESTED_TABLE_SET_SETID | 8.1.5 | QKSFM_ALL | NESTED_TABLE_SET_SETID | |
| NLJ_BATCHING | 11.1.0.6 | QKSFM_EXECUTION | ACCESS | NO_NLJ_BATCHING |
| NLJ_PREFETCH | 11.1.0.6 | QKSFM_EXECUTION | ACCESS | NO_NLJ_PREFETCH |
| NL_AJ | 8.0.0 | QKSFM_CBO | ANTIJOIN | |
| NL_SJ | 8.0.0 | QKSFM_CBO | SEMIJOIN | |
| NOAPPEND | 8.1.0 | QKSFM_CBO | APPEND | APPEND |
| NOCACHE | 8.1.0 | QKSFM_EXECUTION | CACHE | CACHE |
| NOPARALLEL | 8.1.0 | QKSFM_PARALLEL | SHARED | SHARED |
| NO_ACCESS | 8.1.5 | QKSFM_ALL | NO_ACCESS | |
| NO_BASETABLE_MULTIMV_REWRITE | 10.1.0.3 | QKSFM_ALL | REWRITE | REWRITE |
| NO_BIND_AWARE | 11.1.0.7 | QKSFM_CURSOR_SHARING | BIND_AWARE | BIND_AWARE |
| NO_BUFFER | 8.1.5 | QKSFM_CBO | BUFFER | BUFFER |
| NO_CARTESIAN | 10.2.0.1 | QKSFM_ALL | NO_CARTESIAN | |
| NO_CHECK_ACL_REWRITE | 11.1.0.6 | QKSFM_CHECK_ACL_REWRITE | NO_CHECK_ACL_REWRITE | CHECK_ACL_REWRITE |
| NO_COALESCE_SQ | 11.2.0.1 | QKSFM_COALESCE_SQ | COALESCE_SQ | COALESCE_SQ |
| NO_CONNECT_BY_CB_WHR_ONLY | 10.2.0.5 | QKSFM_TRANSFORMATION | CONNECT_BY_CB_WHR_ONLY | CONNECT_BY_CB_WHR_ONLY |
| NO_CONNECT_BY_COMBINE_SW | 10.2.0.4 | QKSFM_ALL | CONNECT_BY_COMBINE_SW | CONNECT_BY_COMBINE_SW |
| NO_CONNECT_BY_COST_BASED | 10.2.0.2 | QKSFM_TRANSFORMATION | CONNECT_BY_COST_BASED | CONNECT_BY_COST_BASED |
| NO_CONNECT_BY_ELIM_DUPS | 11.2.0.1 | QKSFM_ALL | CONNECT_BY_ELIM_DUPS | CONNECT_BY_ELIM_DUPS |
| NO_CONNECT_BY_FILTERING | 10.2.0.2 | QKSFM_ALL | CONNECT_BY_FILTERING | CONNECT_BY_FILTERING |
| NO_COST_XML_QUERY_REWRITE | 11.1.0.6 | QKSFM_COST_XML_QUERY_REWRITE | NO_COST_XML_QUERY_REWRITE | COST_XML_QUERY_REWRITE |
| NO_CPU_COSTING | 9.0.0 | QKSFM_CPU_COSTING | CPU_COSTING | CPU_COSTING |
| NO_DOMAIN_INDEX_FILTER | 11.1.0.6 | QKSFM_CBO | NO_DOMAIN_INDEX_FILTER | DOMAIN_INDEX_FILTER |
| NO_DST_UPGRADE_INSERT_CONV | 11.2.0.1 | QKSFM_ALL | DST_UPGRADE_INSERT_CONV | DST_UPGRADE_INSERT_CONV |
| NO_ELIMINATE_JOIN | 10.2.0.1 | QKSFM_TABLE_ELIM | ELIMINATE_JOIN | ELIMINATE_JOIN |
| NO_ELIMINATE_OBY | 10.2.0.1 | QKSFM_OBYE | ELIMINATE_OBY | ELIMINATE_OBY |
| NO_EXPAND | 8.1.0 | QKSFM_USE_CONCAT | USE_CONCAT | USE_CONCAT |
| NO_EXPAND_GSET_TO_UNION | 9.2.0 | QKSFM_TRANSFORMATION | EXPAND_GSET_TO_UNION | EXPAND_GSET_TO_UNION |
| NO_EXPAND_TABLE | 11.2.0.1 | QKSFM_TABLE_EXPANSION | EXPAND_TABLE | EXPAND_TABLE |
| NO_FACT | 8.1.0 | QKSFM_STAR_TRANS | FACT | FACT |
| NO_FACTORIZE_JOIN | 11.2.0.1 | QKSFM_JOINFAC | FACTORIZE_JOIN | FACTORIZE_JOIN |
| NO_GBY_PUSHDOWN | 11.1.0.6 | QKSFM_ALL | GBY_PUSHDOWN | GBY_PUSHDOWN |
| NO_INDEX | 8.1.5 | QKSFM_INDEX | NO_INDEX | INDEX |
| NO_INDEX_FFS | 10.1.0.3 | QKSFM_INDEX_FFS | NO_INDEX_FFS | INDEX_FFS |
| NO_INDEX_SS | 10.1.0.3 | QKSFM_INDEX_SS | NO_INDEX_SS | INDEX_SS |
| NO_LOAD | 11.1.0.6 | QKSFM_EXECUTION | NO_LOAD | |
| NO_MERGE | 8.0.0 | QKSFM_CVM | MERGE | MERGE |
| NO_MODEL_PUSH_REF | 10.1.0.3 | QKSFM_ALL | MODEL_PUSH_REF | MODEL_PUSH_REF |
| NO_MONITOR | 11.1.0.6 | QKSFM_ALL | MONITOR | MONITOR |
| NO_MONITORING | 8.0.0 | QKSFM_ALL | NO_MONITORING | |
| NO_MULTIMV_REWRITE | 10.1.0.3 | QKSFM_ALL | REWRITE | REWRITE |
| NO_NATIVE_FULL_OUTER_JOIN | 10.2.0.3 | QKSFM_ALL | NATIVE_FULL_OUTER_JOIN | NATIVE_FULL_OUTER_JOIN |
| NO_NLJ_BATCHING | 11.1.0.6 | QKSFM_EXECUTION | ACCESS | NLJ_BATCHING |
| NO_NLJ_PREFETCH | 11.1.0.6 | QKSFM_EXECUTION | ACCESS | NLJ_PREFETCH |
| NO_ORDER_ROLLUPS | 8.0.0 | QKSFM_TRANSFORMATION | NO_ORDER_ROLLUPS | |
| NO_OUTER_JOIN_TO_INNER | 11.1.0.6 | QKSFM_OUTER_JOIN_TO_INNER | OUTER_JOIN_TO_INNER | OUTER_JOIN_TO_INNER |
| NO_PARALLEL | 10.1.0.3 | QKSFM_CBO | SHARED | SHARED |
| NO_PARALLEL_INDEX | 8.1.0 | QKSFM_PQ | PARALLEL_INDEX | PARALLEL_INDEX |
| NO_PARTIAL_COMMIT | 10.1.0.3 | QKSFM_CBO | NO_PARTIAL_COMMIT | |
| NO_PLACE_DISTINCT | 11.2.0.1 | QKSFM_DIST_PLCMT | PLACE_DISTINCT | PLACE_DISTINCT |
| NO_PLACE_GROUP_BY | 11.1.0.6 | QKSFM_PLACE_GROUP_BY | PLACE_GROUP_BY | PLACE_GROUP_BY |
| NO_PRUNE_GSETS | 9.0.0 | QKSFM_TRANSFORMATION | NO_PRUNE_GSETS | |
| NO_PULL_PRED | 10.2.0.1 | QKSFM_PULL_PRED | PULL_PRED | PULL_PRED |
| NO_PUSH_PRED | 8.1.0 | QKSFM_FILTER_PUSH_PRED | PUSH_PRED | PUSH_PRED |
| NO_PUSH_SUBQ | 9.2.0 | QKSFM_TRANSFORMATION | PUSH_SUBQ | PUSH_SUBQ |
| NO_PX_JOIN_FILTER | 10.2.0.1 | QKSFM_PX_JOIN_FILTER | PX_JOIN_FILTER | PX_JOIN_FILTER |
| NO_QKN_BUFF | 9.2.0 | QKSFM_CBO | NO_QKN_BUFF | |
| NO_QUERY_TRANSFORMATION | 10.1.0.3 | QKSFM_TRANSFORMATION | NO_QUERY_TRANSFORMATION | |
| NO_REF_CASCADE | 9.2.0 | QKSFM_CBO | REF_CASCADE_CURSOR | REF_CASCADE_CURSOR |
| NO_RESULT_CACHE | 11.1.0.6 | QKSFM_EXECUTION | RESULT_CACHE | RESULT_CACHE |
| NO_REWRITE | 8.1.5 | QKSFM_TRANSFORMATION | REWRITE | REWRITE |
| NO_SEMIJOIN | 9.0.0 | QKSFM_TRANSFORMATION | SEMIJOIN | SEMIJOIN |
| NO_SET_TO_JOIN | 10.1.0.3 | QKSFM_SET_TO_JOIN | SET_TO_JOIN | SET_TO_JOIN |
| NO_SQL_TUNE | 10.2.0.1 | QKSFM_ALL | NO_SQL_TUNE | |
| NO_STAR_TRANSFORMATION | 10.1.0.3 | QKSFM_STAR_TRANS | STAR_TRANSFORMATION | STAR_TRANSFORMATION |
| NO_STATEMENT_QUEUING | 11.2.0.1 | QKSFM_PARALLEL | STATEMENT_QUEUING | STATEMENT_QUEUING |
| NO_STATS_GSETS | 8.0.0 | QKSFM_ALL | NO_STATS_GSETS | |
| NO_SUBQUERY_PRUNING | 11.1.0.6 | QKSFM_CBO | SUBQUERY_PRUNING | SUBQUERY_PRUNING |
| NO_SUBSTRB_PAD | 11.2.0.1 | QKSFM_EXECUTION | NO_SUBSTRB_PAD | |
| NO_SWAP_JOIN_INPUTS | 10.1.0.3 | QKSFM_CBO | SWAP_JOIN_INPUTS | SWAP_JOIN_INPUTS |
| NO_TRANSFORM_DISTINCT_AGG | 11.2.0.1 | QKSFM_TRANSFORMATION | TRANSFORM_DISTINCT_AGG | TRANSFORM_DISTINCT_AGG |
| NO_UNNEST | 8.1.6 | QKSFM_UNNEST | UNNEST | UNNEST |
| NO_USE_HASH | 10.1.0.3 | QKSFM_USE_HASH | NO_USE_HASH | USE_HASH |
| NO_USE_HASH_AGGREGATION | 10.2.0.1 | QKSFM_ALL | USE_HASH_AGGREGATION | USE_HASH_AGGREGATION |
| NO_USE_INVISIBLE_INDEXES | 11.1.0.6 | QKSFM_INDEX | USE_INVISIBLE_INDEXES | USE_INVISIBLE_INDEXES |
| NO_USE_MERGE | 10.1.0.3 | QKSFM_USE_MERGE | NO_USE_MERGE | USE_MERGE |
| NO_USE_NL | 10.1.0.3 | QKSFM_USE_NL | NO_USE_NL | USE_NL |
| NO_XMLINDEX_REWRITE | 11.1.0.6 | QKSFM_XMLINDEX_REWRITE | XMLINDEX_REWRITE | XMLINDEX_REWRITE |
| NO_XMLINDEX_REWRITE_IN_SELECT | 11.1.0.6 | QKSFM_XMLINDEX_REWRITE | XMLINDEX_REWRITE | XMLINDEX_REWRITE_IN_SELECT |
| NO_XML_DML_REWRITE | 10.2.0.1 | QKSFM_XML_REWRITE | NO_XML_DML_REWRITE | |
| NO_XML_QUERY_REWRITE | 9.2.0 | QKSFM_XML_REWRITE | FORCE_XML_QUERY_REWRITE | FORCE_XML_QUERY_REWRITE |
| NUM_INDEX_KEYS | 10.2.0.3 | QKSFM_CBO | ACCESS | |
| OLD_PUSH_PRED | 10.2.0.1 | QKSFM_OLD_PUSH_PRED | OLD_PUSH_PRED | |
| OPAQUE_TRANSFORM | 10.1.0.3 | QKSFM_TRANSFORMATION | OPAQUE_TRANSFORM | |
| OPAQUE_XCANONICAL | 10.1.0.3 | QKSFM_TRANSFORMATION | OPAQUE_XCANONICAL | |
| OPTIMIZER_FEATURES_ENABLE | 10.1.0.3 | QKSFM_ALL | OPTIMIZER_FEATURES_ENABLE | |
| OPT_ESTIMATE | 10.1.0.3 | QKSFM_OPT_ESTIMATE | OPT_ESTIMATE | |
| OPT_PARAM | 10.2.0.1 | QKSFM_ALL | OPT_PARAM | |
| ORDERED | 8.1.0 | QKSFM_CBO | ORDERED | |
| ORDERED_PREDICATES | 8.0.0 | QKSFM_CBO | ORDERED_PREDICATES | |
| OR_EXPAND | 8.1.7 | QKSFM_OR_EXPAND | OR_EXPAND | |
| OUTER_JOIN_TO_INNER | 11.1.0.6 | QKSFM_OUTER_JOIN_TO_INNER | OUTER_JOIN_TO_INNER | NO_OUTER_JOIN_TO_INNER |
| OUTLINE | 10.2.0.1 | QKSFM_ALL | OUTLINE | |
| OUTLINE_LEAF | 10.2.0.1 | QKSFM_ALL | OUTLINE_LEAF | |
| OVERFLOW_NOMOVE | 9.0.0 | QKSFM_CBO | OVERFLOW_NOMOVE | |
| PARALLEL_INDEX | 8.1.0 | QKSFM_PQ | PARALLEL_INDEX | NO_PARALLEL_INDEX |
| PIV_GB | 8.1.0 | QKSFM_ALL | PIV_GB | |
| PIV_SSF | 8.1.0 | QKSFM_ALL | PIV_SSF | |
| PLACE_DISTINCT | 11.2.0.1 | QKSFM_DIST_PLCMT | PLACE_DISTINCT | NO_PLACE_DISTINCT |
| PLACE_GROUP_BY | 11.1.0.6 | QKSFM_PLACE_GROUP_BY | PLACE_GROUP_BY | NO_PLACE_GROUP_BY |
| PQ_DISTRIBUTE | 8.1.5 | QKSFM_PQ_DISTRIBUTE | PQ_DISTRIBUTE | |
| PQ_MAP | 9.0.0 | QKSFM_PQ_MAP | PQ_MAP | PQ_NOMAP |
| PQ_NOMAP | 9.0.0 | QKSFM_PQ_MAP | PQ_MAP | PQ_MAP |
| PRECOMPUTE_SUBQUERY | 10.2.0.1 | QKSFM_TRANSFORMATION | PRECOMPUTE_SUBQUERY | |
| PRESERVE_OID | 10.2.0.1 | QKSFM_ALL | PRESERVE_OID | |
| PULL_PRED | 10.2.0.1 | QKSFM_PULL_PRED | PULL_PRED | NO_PULL_PRED |
| PUSH_PRED | 8.1.0 | QKSFM_FILTER_PUSH_PRED | PUSH_PRED | NO_PUSH_PRED |
| PUSH_SUBQ | 8.1.0 | QKSFM_TRANSFORMATION | PUSH_SUBQ | NO_PUSH_SUBQ |
| PX_JOIN_FILTER | 10.2.0.1 | QKSFM_PX_JOIN_FILTER | PX_JOIN_FILTER | NO_PX_JOIN_FILTER |
| QB_NAME | 10.1.0.3 | QKSFM_ALL | QB_NAME | |
| QUEUE_CURR | 8.0.0 | QKSFM_CBO | ACCESS | |
| QUEUE_ROWP | 8.0.0 | QKSFM_CBO | ACCESS | |
| RBO_OUTLINE | 10.2.0.1 | QKSFM_RBO | RBO_OUTLINE | |
| REF_CASCADE_CURSOR | 9.2.0 | QKSFM_CBO | REF_CASCADE_CURSOR | NO_REF_CASCADE |
| REMOTE_MAPPED | 8.1.0 | QKSFM_ALL | REMOTE_MAPPED | |
| RESTORE_AS_INTERVALS | 8.1.5 | QKSFM_CBO | RESTORE_AS_INTERVALS | |
| RESTRICT_ALL_REF_CONS | 10.1.0.3 | QKSFM_ALL | RESTRICT_ALL_REF_CONS | |
| RESULT_CACHE | 11.1.0.6 | QKSFM_EXECUTION | RESULT_CACHE | NO_RESULT_CACHE |
| RETRY_ON_ROW_CHANGE | 11.1.0.7 | QKSFM_DML | RETRY_ON_ROW_CHANGE | |
| REWRITE | 8.1.5 | QKSFM_TRANSFORMATION | REWRITE | NO_REWRITE |
| REWRITE_OR_ERROR | 10.1.0.3 | QKSFM_TRANSFORMATION | REWRITE | |
| ROWID | 8.0.0 | QKSFM_CBO | ACCESS | |
| RULE | 8.1.0 | QKSFM_RBO | MODE | |
| SAVE_AS_INTERVALS | 8.1.5 | QKSFM_CBO | SAVE_AS_INTERVALS | |
| SCN_ASCENDING | 8.1.5 | QKSFM_ALL | SCN_ASCENDING | |
| SEMIJOIN | 9.0.0 | QKSFM_TRANSFORMATION | SEMIJOIN | NO_SEMIJOIN |
| SEMIJOIN_DRIVER | 8.1.0 | QKSFM_CBO | SEMIJOIN_DRIVER | |
| SET_TO_JOIN | 10.1.0.3 | QKSFM_SET_TO_JOIN | SET_TO_JOIN | NO_SET_TO_JOIN |
| SHARED | 8.1.0 | QKSFM_PARALLEL | SHARED | NO_PARALLEL |
| SKIP_EXT_OPTIMIZER | 9.0.0 | QKSFM_CBO | SKIP_EXT_OPTIMIZER | |
| SKIP_UNQ_UNUSABLE_IDX | 10.1.0.3 | QKSFM_CBO | SKIP_UNQ_UNUSABLE_IDX | |
| SQLLDR | 9.0.0 | QKSFM_CBO | SQLLDR | |
| STAR | 8.1.0 | QKSFM_STAR_TRANS | STAR | |
| STAR_TRANSFORMATION | 8.1.0 | QKSFM_STAR_TRANS | STAR_TRANSFORMATION | NO_STAR_TRANSFORMATION |
| STATEMENT_QUEUING | 11.2.0.1 | QKSFM_PARALLEL | STATEMENT_QUEUING | NO_STATEMENT_QUEUING |
| STREAMS | 10.1.0.3 | QKSFM_CBO | STREAMS | |
| SUBQUERY_PRUNING | 11.1.0.6 | QKSFM_CBO | SUBQUERY_PRUNING | NO_SUBQUERY_PRUNING |
| SWAP_JOIN_INPUTS | 8.1.0 | QKSFM_CBO | SWAP_JOIN_INPUTS | NO_SWAP_JOIN_INPUTS |
| SYS_DL_CURSOR | 9.2.0 | QKSFM_CBO | SYS_DL_CURSOR | |
| SYS_PARALLEL_TXN | 8.1.6 | QKSFM_CBO | SYS_PARALLEL_TXN | |
| SYS_RID_ORDER | 9.2.0 | QKSFM_ALL | SYS_RID_ORDER | |
| TABLE_STATS | 10.1.0.3 | QKSFM_STATS | TABLE_STATS | |
| TIV_GB | 8.1.0 | QKSFM_ALL | PIV_GB | |
| TIV_SSF | 8.1.0 | QKSFM_ALL | PIV_SSF | |
| TRACING | 10.1.0.3 | QKSFM_EXECUTION | TRACING | |
| TRANSFORM_DISTINCT_AGG | 11.2.0.1 | QKSFM_TRANSFORMATION | TRANSFORM_DISTINCT_AGG | NO_TRANSFORM_DISTINCT_AGG |
| UNNEST | 8.1.6 | QKSFM_UNNEST | UNNEST | NO_UNNEST |
| USE_ANTI | 8.1.0 | QKSFM_CBO | USE_ANTI | |
| USE_CONCAT | 8.1.0 | QKSFM_USE_CONCAT | USE_CONCAT | NO_EXPAND |
| USE_HASH | 8.1.0 | QKSFM_USE_HASH | JOIN | NO_USE_HASH |
| USE_HASH_AGGREGATION | 10.2.0.1 | QKSFM_ALL | USE_HASH_AGGREGATION | NO_USE_HASH_AGGREGATION |
| USE_INVISIBLE_INDEXES | 11.1.0.6 | QKSFM_INDEX | USE_INVISIBLE_INDEXES | NO_USE_INVISIBLE_INDEXES |
| USE_MERGE | 8.1.0 | QKSFM_USE_MERGE | JOIN | NO_USE_MERGE |
| USE_MERGE_CARTESIAN | 11.1.0.6 | QKSFM_USE_MERGE_CARTESIAN | JOIN | |
| USE_NL | 8.1.0 | QKSFM_USE_NL | JOIN | NO_USE_NL |
| USE_NL_WITH_INDEX | 10.1.0.3 | QKSFM_USE_NL_WITH_INDEX | USE_NL_WITH_INDEX | NO_USE_NL |
| USE_SEMI | 8.1.0 | QKSFM_CBO | USE_SEMI | |
| USE_TTT_FOR_GSETS | 9.0.0 | QKSFM_TRANSFORMATION | USE_TTT_FOR_GSETS | |
| USE_WEAK_NAME_RESL | 10.1.0.3 | QKSFM_ALL | USE_WEAK_NAME_RESL | |
| VECTOR_READ | 10.1.0.3 | QKSFM_CBO | VECTOR_READ | |
| VECTOR_READ_TRACE | 10.1.0.3 | QKSFM_CBO | VECTOR_READ_TRACE | |
| XMLINDEX_REWRITE | 11.1.0.6 | QKSFM_XMLINDEX_REWRITE | XMLINDEX_REWRITE | NO_XMLINDEX_REWRITE |
| XMLINDEX_REWRITE_IN_SELECT | 11.1.0.6 | QKSFM_XMLINDEX_REWRITE | XMLINDEX_REWRITE | NO_XMLINDEX_REWRITE_IN_SELECT |
| XMLINDEX_SEL_IDX_TBL | 11.2.0.1 | QKSFM_ALL | XMLINDEX_SEL_IDX_TBL | |
| XML_DML_RWT_STMT | 11.1.0.6 | QKSFM_XML_REWRITE | XML_DML_RWT_STMT | |
| X_DYN_PRUNE | 10.1.0.3 | QKSFM_CBO | X_DYN_PRUNE |