BigdataLyn's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 19c Hint list Tips

2021-07-28

Oracle 19c Hint list Tips

List hint in 19c from V$SQL_HINT.

Hint list

Total hint: 373

SYSTEM@pdb1> select substr(version,1,2),count(*) from v$sql_hint group by substr(version,1,2);

SUBSTR(V   COUNT(*)
-------- ----------
9.               39
8.               85
12               78
18               15
10               80
11               70
19                6

7 rows selected.

SYSTEM@pdb1> 
SYSTEM@pdb1> select BANNER from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SYSTEM@pdb1> 
SYSTEM@pdb1> set pagesize 500 linesize 300
SYSTEM@pdb1> @colfmt
COL "VERSION"                        FOR A8
COL "HINT_NAME"                      FOR A30
COL "INVERSE"                        FOR A30
COL "CLASS"                          FOR A27
COL "SQL_FEATURE"                    FOR A30
SELECT VERSION,NAME HINT_NAME,INVERSE,CLASS,SQL_FEATURE
FROM V$SQL_HINT
ORDER BY
TO_NUMBER(REGEXP_REPLACE(REGEXP_REPLACE(VERSION,'\.','',1,2),'\.','',1,2),99.999) DESC
,CLASS,NAME;

VERSION  HINT_NAME                      INVERSE                        CLASS                       SQL_FEATURE
-------- ------------------------------ ------------------------------ --------------------------- ------------------------------
19.1.0   JSON_LENGTH                                                   JSON_LENGTH                 QKSFM_EXECUTION
19.1.0   NO_PQ_EXPAND_TABLE             PQ_EXPAND_TABLE                PQ_EXPAND_TABLE             QKSFM_TABLE_EXPANSION
19.1.0   PQ_EXPAND_TABLE                NO_PQ_EXPAND_TABLE             PQ_EXPAND_TABLE             QKSFM_TABLE_EXPANSION
19.1.0   QUARANTINE                                                    QUARANTINE                  QKSFM_EXECUTION
19.1.0   NO_USE_SCALABLE_GBY_INVDIST    USE_SCALABLE_GBY_INVDIST       USE_SCALABLE_GBY_INVDIST    QKSFM_PQ
19.1.0   USE_SCALABLE_GBY_INVDIST       NO_USE_SCALABLE_GBY_INVDIST    USE_SCALABLE_GBY_INVDIST    QKSFM_PQ
18.1.0   ANSWER_QUERY_USING_STATS       NO_ANSWER_QUERY_USING_STATS    ANSWER_QUERY_USING_STATS    QKSFM_ANSWER_QUERY_USING_STATS
18.1.0   NO_ANSWER_QUERY_USING_STATS    ANSWER_QUERY_USING_STATS       ANSWER_QUERY_USING_STATS    QKSFM_ANSWER_QUERY_USING_STATS
18.1.0   AV_CACHE                                                      AV_CACHE                    QKSFM_EXECUTION
18.1.0   CURRENT_INSTANCE                                              CURRENT_INSTANCE            QKSFM_ALL
18.1.0   MEMOPTIMIZE_WRITE                                             MEMOPTIMIZE_WRITE           QKSFM_EXECUTION
18.1.0   PDB_LOCAL_ONLY                                                PDB_LOCAL_ONLY              QKSFM_DML
18.1.0   NO_PUSH_HAVING_TO_GBY          PUSH_HAVING_TO_GBY             PUSH_HAVING_TO_GBY          QKSFM_EXECUTION
18.1.0   PUSH_HAVING_TO_GBY             NO_PUSH_HAVING_TO_GBY          PUSH_HAVING_TO_GBY          QKSFM_EXECUTION
18.1.0   NO_REORDER_WIF                 REORDER_WIF                    REORDER_WIF                 QKSFM_PARTITION
18.1.0   REORDER_WIF                    NO_REORDER_WIF                 REORDER_WIF                 QKSFM_PARTITION
18.1.0   SKIP_PROXY                                                    SKIP_PROXY                  QKSFM_ALL
18.1.0   SUPPRESS_LOAD                                                 SUPPRESS_LOAD               QKSFM_DDL
18.1.0   SYSTEM_STATS                                                  SYSTEM_STATS                QKSFM_ALL
18.1.0   NO_USE_PARTITION_WISE_WIF      USE_PARTITION_WISE_WIF         USE_PARTITION_WISE_WIF      QKSFM_PARTITION
18.1.0   USE_PARTITION_WISE_WIF         NO_USE_PARTITION_WISE_WIF      USE_PARTITION_WISE_WIF      QKSFM_PARTITION
12.2.0.1 BUSHY_JOIN                     NO_BUSHY_JOIN                  BUSHY_JOIN                  QKSFM_BUSHY_JOIN
12.2.0.1 NO_BUSHY_JOIN                  BUSHY_JOIN                     BUSHY_JOIN                  QKSFM_BUSHY_JOIN
12.2.0.1 CONTAINERS                                                    CONTAINERS                  QKSFM_ALL
12.2.0.1 DATA_VALIDATE                                                 DATA_VALIDATE               QKSFM_EXECUTION
12.2.0.1 DIST_AGG_PROLLUP_PUSHDOWN      NO_DIST_AGG_PROLLUP_PUSHDOWN   DIST_AGG_PROLLUP_PUSHDOWN   QKSFM_PQ
12.2.0.1 NO_DIST_AGG_PROLLUP_PUSHDOWN   DIST_AGG_PROLLUP_PUSHDOWN      DIST_AGG_PROLLUP_PUSHDOWN   QKSFM_PQ
12.2.0.1 ELIMINATE_SQ                   NO_ELIMINATE_SQ                ELIMINATE_SQ                QKSFM_ELIMINATE_SQ
12.2.0.1 NO_ELIMINATE_SQ                ELIMINATE_SQ                   ELIMINATE_SQ                QKSFM_ELIMINATE_SQ
12.2.0.1 FRESH_MV                                                      FRESH_MV                    QKSFM_MVIEWS
12.2.0.1 ORDER_SUBQ                                                    ORDER_SUBQ                  QKSFM_TRANSFORMATION
12.2.0.1 NO_OR_EXPAND                   OR_EXPAND                      OR_EXPAND                   QKSFM_CBQT_OR_EXPANSION
12.2.0.1 OR_EXPAND                      NO_OR_EXPAND                   OR_EXPAND                   QKSFM_CBQT_OR_EXPANSION
12.2.0.1 SQL_SCOPE                                                     SQL_SCOPE                   QKSFM_COMPILATION
12.2.0.1 NO_USE_DAGG_UNION_ALL_GSETS    USE_DAGG_UNION_ALL_GSETS       USE_DAGG_UNION_ALL_GSETS    QKSFM_GROUPING_SET_XFORM
12.2.0.1 USE_DAGG_UNION_ALL_GSETS       NO_USE_DAGG_UNION_ALL_GSETS    USE_DAGG_UNION_ALL_GSETS    QKSFM_GROUPING_SET_XFORM
12.2.0.1 NO_USE_HASH_GBY_FOR_DAGGPSHD   USE_HASH_GBY_FOR_DAGGPSHD      USE_HASH_GBY_FOR_DAGGPSHD   QKSFM_ALL
12.2.0.1 USE_HASH_GBY_FOR_DAGGPSHD      NO_USE_HASH_GBY_FOR_DAGGPSHD   USE_HASH_GBY_FOR_DAGGPSHD   QKSFM_ALL
12.2.0.1 NO_USE_PARTITION_WISE_DISTINCT USE_PARTITION_WISE_DISTINCT    USE_PARTITION_WISE_DISTINCT QKSFM_PARTITION
12.2.0.1 USE_PARTITION_WISE_DISTINCT    NO_USE_PARTITION_WISE_DISTINCT USE_PARTITION_WISE_DISTINCT QKSFM_PARTITION
12.2.0.1 NO_USE_PARTITION_WISE_GBY      USE_PARTITION_WISE_GBY         USE_PARTITION_WISE_GBY      QKSFM_PARTITION
12.2.0.1 USE_PARTITION_WISE_GBY         NO_USE_PARTITION_WISE_GBY      USE_PARTITION_WISE_GBY      QKSFM_PARTITION
12.2.0.1 XMLTSET_DML_ENABLE                                            XMLTSET_DML_ENABLE          QKSFM_ALL
12.1.0.2 ADAPTIVE_PLAN                  NO_ADAPTIVE_PLAN               ADAPTIVE_PLAN               QKSFM_ADAPTIVE_PLAN
12.1.0.2 NO_ADAPTIVE_PLAN               ADAPTIVE_PLAN                  ADAPTIVE_PLAN               QKSFM_ADAPTIVE_PLAN
12.1.0.2 ANSI_REARCH                    NO_ANSI_REARCH                 ANSI_REARCH                 QKSFM_ANSI_REARCH
12.1.0.2 NO_ANSI_REARCH                 ANSI_REARCH                    ANSI_REARCH                 QKSFM_ANSI_REARCH
12.1.0.2 ELIM_GROUPBY                   NO_ELIM_GROUPBY                ELIM_GROUPBY                QKSFM_TRANSFORMATION
12.1.0.2 NO_ELIM_GROUPBY                ELIM_GROUPBY                   ELIM_GROUPBY                QKSFM_TRANSFORMATION
12.1.0.2 INMEMORY                       NO_INMEMORY                    INMEMORY                    QKSFM_EXECUTION
12.1.0.2 NO_INMEMORY                    INMEMORY                       INMEMORY                    QKSFM_EXECUTION
12.1.0.2 INMEMORY_PRUNING               NO_INMEMORY_PRUNING            INMEMORY_PRUNING            QKSFM_EXECUTION
12.1.0.2 NO_INMEMORY_PRUNING            INMEMORY_PRUNING               INMEMORY_PRUNING            QKSFM_EXECUTION
12.1.0.2 RESERVOIR_SAMPLING                                            RESERVOIR_SAMPLING          QKSFM_EXECUTION
12.1.0.2 NO_USE_VECTOR_AGGREGATION      USE_VECTOR_AGGREGATION         USE_VECTOR_AGGREGATION      QKSFM_VECTOR_AGG
12.1.0.2 USE_VECTOR_AGGREGATION         NO_USE_VECTOR_AGGREGATION      USE_VECTOR_AGGREGATION      QKSFM_VECTOR_AGG
12.1.0.2 NO_VECTOR_TRANSFORM            VECTOR_TRANSFORM               VECTOR_TRANSFORM            QKSFM_VECTOR_AGG
12.1.0.2 VECTOR_TRANSFORM               NO_VECTOR_TRANSFORM            VECTOR_TRANSFORM            QKSFM_VECTOR_AGG
12.1.0.2 NO_VECTOR_TRANSFORM_DIMS       VECTOR_TRANSFORM_DIMS          VECTOR_TRANSFORM_DIMS       QKSFM_VECTOR_AGG
12.1.0.2 VECTOR_TRANSFORM_DIMS          NO_VECTOR_TRANSFORM_DIMS       VECTOR_TRANSFORM_DIMS       QKSFM_VECTOR_AGG
12.1.0.2 NO_VECTOR_TRANSFORM_FACT       VECTOR_TRANSFORM_FACT          VECTOR_TRANSFORM_FACT       QKSFM_VECTOR_AGG
12.1.0.2 VECTOR_TRANSFORM_FACT          NO_VECTOR_TRANSFORM_FACT       VECTOR_TRANSFORM_FACT       QKSFM_VECTOR_AGG
12.1.0.1 CUBE_AJ                                                       ANTIJOIN                    QKSFM_JOIN_METHOD
12.1.0.1 AUTO_REOPTIMIZE                NO_AUTO_REOPTIMIZE             AUTO_REOPTIMIZE             QKSFM_AUTO_REOPT
12.1.0.1 NO_AUTO_REOPTIMIZE             AUTO_REOPTIMIZE                AUTO_REOPTIMIZE             QKSFM_AUTO_REOPT
12.1.0.1 BATCH_TABLE_ACCESS_BY_ROWID    NO_BATCH_TABLE_ACCESS_BY_ROWID BATCH_TABLE_ACCESS_BY_ROWID QKSFM_EXECUTION
12.1.0.1 NO_BATCH_TABLE_ACCESS_BY_ROWID BATCH_TABLE_ACCESS_BY_ROWID    BATCH_TABLE_ACCESS_BY_ROWID QKSFM_EXECUTION
12.1.0.1 BITMAP_AND                                                    BITMAP_AND                  QKSFM_BITMAP_TREE
12.1.0.1 CLUSTERING                     NO_CLUSTERING                  CLUSTERING                  QKSFM_CLUSTERING
12.1.0.1 NO_CLUSTERING                  CLUSTERING                     CLUSTERING                  QKSFM_CLUSTERING
12.1.0.1 CLUSTER_BY_ROWID               NO_CLUSTER_BY_ROWID            CLUSTER_BY_ROWID            QKSFM_CBO
12.1.0.1 NO_CLUSTER_BY_ROWID            CLUSTER_BY_ROWID               CLUSTER_BY_ROWID            QKSFM_CBO
12.1.0.1 DATA_SECURITY_REWRITE_LIMIT    NO_DATA_SECURITY_REWRITE       DATA_SECURITY_REWRITE_LIMIT QKSFM_DATA_SECURITY_REWRITE
12.1.0.1 NO_DATA_SECURITY_REWRITE       DATA_SECURITY_REWRITE_LIMIT    DATA_SECURITY_REWRITE_LIMIT QKSFM_DATA_SECURITY_REWRITE
12.1.0.1 DECORRELATE                    NO_DECORRELATE                 DECORRELATE                 QKSFM_DECORRELATE
12.1.0.1 NO_DECORRELATE                 DECORRELATE                    DECORRELATE                 QKSFM_DECORRELATE
12.1.0.1 GATHER_OPTIMIZER_STATISTICS    NO_GATHER_OPTIMIZER_STATISTICS GATHER_OPTIMIZER_STATISTICS QKSFM_DBMS_STATS
12.1.0.1 NO_GATHER_OPTIMIZER_STATISTICS GATHER_OPTIMIZER_STATISTICS    GATHER_OPTIMIZER_STATISTICS QKSFM_DBMS_STATS
12.1.0.1 NO_USE_CUBE                    USE_CUBE                       JOIN                        QKSFM_USE_CUBE
12.1.0.1 USE_CUBE                       NO_USE_CUBE                    JOIN                        QKSFM_USE_CUBE
12.1.0.1 NO_PARTIAL_JOIN                PARTIAL_JOIN                   PARTIAL_JOIN                QKSFM_PARTIAL_JOIN
12.1.0.1 PARTIAL_JOIN                   NO_PARTIAL_JOIN                PARTIAL_JOIN                QKSFM_PARTIAL_JOIN
12.1.0.1 NO_PARTIAL_ROLLUP_PUSHDOWN     PARTIAL_ROLLUP_PUSHDOWN        PARTIAL_ROLLUP_PUSHDOWN     QKSFM_PQ
12.1.0.1 PARTIAL_ROLLUP_PUSHDOWN        NO_PARTIAL_ROLLUP_PUSHDOWN     PARTIAL_ROLLUP_PUSHDOWN     QKSFM_PQ
12.1.0.1 NO_PQ_CONCURRENT_UNION         PQ_CONCURRENT_UNION            PQ_CONCURRENT_UNION         QKSFM_PQ
12.1.0.1 PQ_CONCURRENT_UNION            NO_PQ_CONCURRENT_UNION         PQ_CONCURRENT_UNION         QKSFM_PQ
12.1.0.1 PQ_DISTRIBUTE_WINDOW                                          PQ_DISTRIBUTE_WINDOW        QKSFM_PQ
12.1.0.1 PQ_FILTER                                                     PQ_FILTER                   QKSFM_PQ
12.1.0.1 NO_PQ_REPLICATE                PQ_REPLICATE                   PQ_REPLICATE                QKSFM_PQ_REPLICATE
12.1.0.1 PQ_REPLICATE                   NO_PQ_REPLICATE                PQ_REPLICATE                QKSFM_PQ_REPLICATE
12.1.0.1 NO_PQ_SKEW                     PQ_SKEW                        PQ_SKEW                     QKSFM_PQ
12.1.0.1 PQ_SKEW                        NO_PQ_SKEW                     PQ_SKEW                     QKSFM_PQ
12.1.0.1 NO_PX_FAULT_TOLERANCE          PX_FAULT_TOLERANCE             PX_FAULT_TOLERANCE          QKSFM_PQ
12.1.0.1 PX_FAULT_TOLERANCE             NO_PX_FAULT_TOLERANCE          PX_FAULT_TOLERANCE          QKSFM_PQ
12.1.0.1 CUBE_SJ                                                       SEMIJOIN                    QKSFM_JOIN_METHOD
12.1.0.1 USE_HIDDEN_PARTITIONS                                         USE_HIDDEN_PARTITIONS       QKSFM_PARTITION
12.1.0.1 WITH_PLSQL                                                    WITH_PLSQL                  QKSFM_ALL
12.1.0.1 NO_ZONEMAP                     ZONEMAP                        ZONEMAP                     QKSFM_ZONEMAP
12.1.0.1 ZONEMAP                        NO_ZONEMAP                     ZONEMAP                     QKSFM_ZONEMAP
11.2.0.4 DISABLE_PARALLEL_DML           ENABLE_PARALLEL_DML            ENABLE_PARALLEL_DML         QKSFM_DML
11.2.0.4 ENABLE_PARALLEL_DML            DISABLE_PARALLEL_DML           ENABLE_PARALLEL_DML         QKSFM_DML
11.2.0.3 FULL_OUTER_JOIN_TO_OUTER       NO_FULL_OUTER_JOIN_TO_OUTER    FULL_OUTER_JOIN_TO_OUTER    QKSFM_CBO
11.2.0.3 NO_FULL_OUTER_JOIN_TO_OUTER    FULL_OUTER_JOIN_TO_OUTER       FULL_OUTER_JOIN_TO_OUTER    QKSFM_CBO
11.2.0.3 NO_SEMI_TO_INNER               SEMI_TO_INNER                  NO_SEMI_TO_INNER            QKSFM_CBO
11.2.0.3 NO_OUTER_JOIN_TO_ANTI          OUTER_JOIN_TO_ANTI             OUTER_JOIN_TO_ANTI          QKSFM_CBO
11.2.0.3 OUTER_JOIN_TO_ANTI             NO_OUTER_JOIN_TO_ANTI          OUTER_JOIN_TO_ANTI          QKSFM_CBO
11.2.0.3 SEMI_TO_INNER                  NO_SEMI_TO_INNER               SEMI_TO_INNER               QKSFM_CBO
11.2.0.2 NO_TABLE_LOOKUP_BY_NL          TABLE_LOOKUP_BY_NL             TABLE_LOOKUP_BY_NL          QKSFM_TABLE_LOOKUP_BY_NL
11.2.0.2 TABLE_LOOKUP_BY_NL             NO_TABLE_LOOKUP_BY_NL          TABLE_LOOKUP_BY_NL          QKSFM_TABLE_LOOKUP_BY_NL
11.2.0.2 NO_USE_HASH_GBY_FOR_PUSHDOWN   USE_HASH_GBY_FOR_PUSHDOWN      USE_HASH_GBY_FOR_PUSHDOWN   QKSFM_ALL
11.2.0.2 USE_HASH_GBY_FOR_PUSHDOWN      NO_USE_HASH_GBY_FOR_PUSHDOWN   USE_HASH_GBY_FOR_PUSHDOWN   QKSFM_ALL
11.2.0.2 NO_XDB_FASTPATH_INSERT         XDB_FASTPATH_INSERT            XDB_FASTPATH_INSERT         QKSFM_ALL
11.2.0.2 XDB_FASTPATH_INSERT            NO_XDB_FASTPATH_INSERT         XDB_FASTPATH_INSERT         QKSFM_ALL
11.2.0.1 APPEND_VALUES                  NOAPPEND                       APPEND_VALUES               QKSFM_CBO
11.2.0.1 COALESCE_SQ                    NO_COALESCE_SQ                 COALESCE_SQ                 QKSFM_COALESCE_SQ
11.2.0.1 NO_COALESCE_SQ                 COALESCE_SQ                    COALESCE_SQ                 QKSFM_COALESCE_SQ
11.2.0.1 CONNECT_BY_ELIM_DUPS           NO_CONNECT_BY_ELIM_DUPS        CONNECT_BY_ELIM_DUPS        QKSFM_ALL
11.2.0.1 NO_CONNECT_BY_ELIM_DUPS        CONNECT_BY_ELIM_DUPS           CONNECT_BY_ELIM_DUPS        QKSFM_ALL
11.2.0.1 DST_UPGRADE_INSERT_CONV        NO_DST_UPGRADE_INSERT_CONV     DST_UPGRADE_INSERT_CONV     QKSFM_ALL
11.2.0.1 NO_DST_UPGRADE_INSERT_CONV     DST_UPGRADE_INSERT_CONV        DST_UPGRADE_INSERT_CONV     QKSFM_ALL
11.2.0.1 EXPAND_TABLE                   NO_EXPAND_TABLE                EXPAND_TABLE                QKSFM_TABLE_EXPANSION
11.2.0.1 NO_EXPAND_TABLE                EXPAND_TABLE                   EXPAND_TABLE                QKSFM_TABLE_EXPANSION
11.2.0.1 FACTORIZE_JOIN                 NO_FACTORIZE_JOIN              FACTORIZE_JOIN              QKSFM_JOINFAC
11.2.0.1 NO_FACTORIZE_JOIN              FACTORIZE_JOIN                 FACTORIZE_JOIN              QKSFM_JOINFAC
11.2.0.1 NO_SUBSTRB_PAD                                                NO_SUBSTRB_PAD              QKSFM_EXECUTION
11.2.0.1 NO_PLACE_DISTINCT              PLACE_DISTINCT                 PLACE_DISTINCT              QKSFM_DIST_PLCMT
11.2.0.1 PLACE_DISTINCT                 NO_PLACE_DISTINCT              PLACE_DISTINCT              QKSFM_DIST_PLCMT
11.2.0.1 NO_STATEMENT_QUEUING           STATEMENT_QUEUING              STATEMENT_QUEUING           QKSFM_PARALLEL
11.2.0.1 STATEMENT_QUEUING              NO_STATEMENT_QUEUING           STATEMENT_QUEUING           QKSFM_PARALLEL
11.2.0.1 NO_TRANSFORM_DISTINCT_AGG      TRANSFORM_DISTINCT_AGG         TRANSFORM_DISTINCT_AGG      QKSFM_TRANSFORMATION
11.2.0.1 TRANSFORM_DISTINCT_AGG         NO_TRANSFORM_DISTINCT_AGG      TRANSFORM_DISTINCT_AGG      QKSFM_TRANSFORMATION
11.2.0.1 XMLINDEX_SEL_IDX_TBL                                          XMLINDEX_SEL_IDX_TBL        QKSFM_ALL
11.1.0.7 BIND_AWARE                     NO_BIND_AWARE                  BIND_AWARE                  QKSFM_CURSOR_SHARING
11.1.0.7 NO_BIND_AWARE                  BIND_AWARE                     BIND_AWARE                  QKSFM_CURSOR_SHARING
11.1.0.7 CHANGE_DUPKEY_ERROR_INDEX                                     CHANGE_DUPKEY_ERROR_INDEX   QKSFM_DML
11.1.0.7 IGNORE_ROW_ON_DUPKEY_INDEX                                    IGNORE_ROW_ON_DUPKEY_INDEX  QKSFM_DML
11.1.0.7 RETRY_ON_ROW_CHANGE                                           RETRY_ON_ROW_CHANGE         QKSFM_DML
11.1.0.6 INDEX_RS_ASC                                                  ACCESS                      QKSFM_INDEX_RS_ASC
11.1.0.6 INDEX_RS_DESC                                                 ACCESS                      QKSFM_INDEX_RS_DESC
11.1.0.6 NLJ_BATCHING                   NO_NLJ_BATCHING                ACCESS                      QKSFM_EXECUTION
11.1.0.6 NLJ_PREFETCH                   NO_NLJ_PREFETCH                ACCESS                      QKSFM_EXECUTION
11.1.0.6 NO_NLJ_BATCHING                NLJ_BATCHING                   ACCESS                      QKSFM_EXECUTION
11.1.0.6 NO_NLJ_PREFETCH                NLJ_PREFETCH                   ACCESS                      QKSFM_EXECUTION
11.1.0.6 CHECK_ACL_REWRITE              NO_CHECK_ACL_REWRITE           CHECK_ACL_REWRITE           QKSFM_CHECK_ACL_REWRITE
11.1.0.6 COST_XML_QUERY_REWRITE         NO_COST_XML_QUERY_REWRITE      COST_XML_QUERY_REWRITE      QKSFM_COST_XML_QUERY_REWRITE
11.1.0.6 DB_VERSION                                                    DB_VERSION                  QKSFM_ALL
11.1.0.6 DOMAIN_INDEX_FILTER            NO_DOMAIN_INDEX_FILTER         DOMAIN_INDEX_FILTER         QKSFM_CBO
11.1.0.6 USE_MERGE_CARTESIAN                                           JOIN                        QKSFM_USE_MERGE_CARTESIAN
11.1.0.6 MONITOR                        NO_MONITOR                     MONITOR                     QKSFM_ALL
11.1.0.6 NO_MONITOR                     MONITOR                        MONITOR                     QKSFM_ALL
11.1.0.6 NO_CHECK_ACL_REWRITE           CHECK_ACL_REWRITE              NO_CHECK_ACL_REWRITE        QKSFM_CHECK_ACL_REWRITE
11.1.0.6 NO_COST_XML_QUERY_REWRITE      COST_XML_QUERY_REWRITE         NO_COST_XML_QUERY_REWRITE   QKSFM_COST_XML_QUERY_REWRITE
11.1.0.6 NO_DOMAIN_INDEX_FILTER         DOMAIN_INDEX_FILTER            NO_DOMAIN_INDEX_FILTER      QKSFM_CBO
11.1.0.6 NO_LOAD                                                       NO_LOAD                     QKSFM_EXECUTION
11.1.0.6 NO_OUTER_JOIN_TO_INNER         OUTER_JOIN_TO_INNER            OUTER_JOIN_TO_INNER         QKSFM_OUTER_JOIN_TO_INNER
11.1.0.6 OUTER_JOIN_TO_INNER            NO_OUTER_JOIN_TO_INNER         OUTER_JOIN_TO_INNER         QKSFM_OUTER_JOIN_TO_INNER
11.1.0.6 NO_PLACE_GROUP_BY              PLACE_GROUP_BY                 PLACE_GROUP_BY              QKSFM_PLACE_GROUP_BY
11.1.0.6 PLACE_GROUP_BY                 NO_PLACE_GROUP_BY              PLACE_GROUP_BY              QKSFM_PLACE_GROUP_BY
11.1.0.6 NO_RESULT_CACHE                RESULT_CACHE                   RESULT_CACHE                QKSFM_EXECUTION
11.1.0.6 RESULT_CACHE                   NO_RESULT_CACHE                RESULT_CACHE                QKSFM_EXECUTION
11.1.0.6 NO_SUBQUERY_PRUNING            SUBQUERY_PRUNING               SUBQUERY_PRUNING            QKSFM_CBO
11.1.0.6 SUBQUERY_PRUNING               NO_SUBQUERY_PRUNING            SUBQUERY_PRUNING            QKSFM_CBO
11.1.0.6 NO_USE_INVISIBLE_INDEXES       USE_INVISIBLE_INDEXES          USE_INVISIBLE_INDEXES       QKSFM_INDEX
11.1.0.6 USE_INVISIBLE_INDEXES          NO_USE_INVISIBLE_INDEXES       USE_INVISIBLE_INDEXES       QKSFM_INDEX
11.1.0.6 NO_XMLINDEX_REWRITE            XMLINDEX_REWRITE               XMLINDEX_REWRITE            QKSFM_XMLINDEX_REWRITE
11.1.0.6 NO_XMLINDEX_REWRITE_IN_SELECT  XMLINDEX_REWRITE_IN_SELECT     XMLINDEX_REWRITE            QKSFM_XMLINDEX_REWRITE
11.1.0.6 XMLINDEX_REWRITE               NO_XMLINDEX_REWRITE            XMLINDEX_REWRITE            QKSFM_XMLINDEX_REWRITE
11.1.0.6 XMLINDEX_REWRITE_IN_SELECT     NO_XMLINDEX_REWRITE_IN_SELECT  XMLINDEX_REWRITE            QKSFM_XMLINDEX_REWRITE
11.1.0.6 XML_DML_RWT_STMT                                              XML_DML_RWT_STMT            QKSFM_XML_REWRITE
10.2.0.5 CONNECT_BY_CB_WHR_ONLY         NO_CONNECT_BY_CB_WHR_ONLY      CONNECT_BY_CB_WHR_ONLY      QKSFM_TRANSFORMATION
10.2.0.5 NO_CONNECT_BY_CB_WHR_ONLY      CONNECT_BY_CB_WHR_ONLY         CONNECT_BY_CB_WHR_ONLY      QKSFM_TRANSFORMATION
10.2.0.5 GBY_PUSHDOWN                   NO_GBY_PUSHDOWN                GBY_PUSHDOWN                QKSFM_ALL
10.2.0.5 NO_GBY_PUSHDOWN                GBY_PUSHDOWN                   GBY_PUSHDOWN                QKSFM_ALL
10.2.0.4 CONNECT_BY_COMBINE_SW          NO_CONNECT_BY_COMBINE_SW       CONNECT_BY_COMBINE_SW       QKSFM_ALL
10.2.0.4 NO_CONNECT_BY_COMBINE_SW       CONNECT_BY_COMBINE_SW          CONNECT_BY_COMBINE_SW       QKSFM_ALL
10.2.0.3 NUM_INDEX_KEYS                                                ACCESS                      QKSFM_CBO
10.2.0.3 NATIVE_FULL_OUTER_JOIN         NO_NATIVE_FULL_OUTER_JOIN      NATIVE_FULL_OUTER_JOIN      QKSFM_ALL
10.2.0.3 NO_NATIVE_FULL_OUTER_JOIN      NATIVE_FULL_OUTER_JOIN         NATIVE_FULL_OUTER_JOIN      QKSFM_ALL
10.2.0.2 CONNECT_BY_COST_BASED          NO_CONNECT_BY_COST_BASED       CONNECT_BY_COST_BASED       QKSFM_TRANSFORMATION
10.2.0.2 NO_CONNECT_BY_COST_BASED       CONNECT_BY_COST_BASED          CONNECT_BY_COST_BASED       QKSFM_TRANSFORMATION
10.2.0.2 CONNECT_BY_FILTERING           NO_CONNECT_BY_FILTERING        CONNECT_BY_FILTERING        QKSFM_ALL
10.2.0.2 NO_CONNECT_BY_FILTERING        CONNECT_BY_FILTERING           CONNECT_BY_FILTERING        QKSFM_ALL
10.2.0.1 BITMAP_TREE                                                   ACCESS                      QKSFM_BITMAP_TREE
10.2.0.1 DBMS_STATS                                                    DBMS_STATS                  QKSFM_DBMS_STATS
10.2.0.1 ELIMINATE_JOIN                 NO_ELIMINATE_JOIN              ELIMINATE_JOIN              QKSFM_TABLE_ELIM
10.2.0.1 NO_ELIMINATE_JOIN              ELIMINATE_JOIN                 ELIMINATE_JOIN              QKSFM_TABLE_ELIM
10.2.0.1 ELIMINATE_OBY                  NO_ELIMINATE_OBY               ELIMINATE_OBY               QKSFM_OBYE
10.2.0.1 NO_ELIMINATE_OBY               ELIMINATE_OBY                  ELIMINATE_OBY               QKSFM_OBYE
10.2.0.1 INLINE_XMLTYPE_NT                                             INLINE_XMLTYPE_NT           QKSFM_ALL
10.2.0.1 MODEL_COMPILE_SUBQUERY                                        MODEL_COMPILE_SUBQUERY      QKSFM_TRANSFORMATION
10.2.0.1 MODEL_DYNAMIC_SUBQUERY                                        MODEL_DYNAMIC_SUBQUERY      QKSFM_TRANSFORMATION
10.2.0.1 NO_CARTESIAN                                                  NO_CARTESIAN                QKSFM_ALL
10.2.0.1 NO_SQL_TUNE                                                   NO_SQL_TUNE                 QKSFM_ALL
10.2.0.1 NO_XML_DML_REWRITE                                            NO_XML_DML_REWRITE          QKSFM_XML_REWRITE
10.2.0.1 OLD_PUSH_PRED                                                 OLD_PUSH_PRED               QKSFM_OLD_PUSH_PRED
10.2.0.1 OPT_PARAM                                                     OPT_PARAM                   QKSFM_ALL
10.2.0.1 OUTLINE                                                       OUTLINE                     QKSFM_ALL
10.2.0.1 OUTLINE_LEAF                                                  OUTLINE_LEAF                QKSFM_ALL
10.2.0.1 PRECOMPUTE_SUBQUERY                                           PRECOMPUTE_SUBQUERY         QKSFM_TRANSFORMATION
10.2.0.1 PRESERVE_OID                                                  PRESERVE_OID                QKSFM_ALL
10.2.0.1 NO_PULL_PRED                   PULL_PRED                      PULL_PRED                   QKSFM_PULL_PRED
10.2.0.1 PULL_PRED                      NO_PULL_PRED                   PULL_PRED                   QKSFM_PULL_PRED
10.2.0.1 NO_PX_JOIN_FILTER              PX_JOIN_FILTER                 PX_JOIN_FILTER              QKSFM_PX_JOIN_FILTER
10.2.0.1 PX_JOIN_FILTER                 NO_PX_JOIN_FILTER              PX_JOIN_FILTER              QKSFM_PX_JOIN_FILTER
10.2.0.1 RBO_OUTLINE                                                   RBO_OUTLINE                 QKSFM_RBO
10.2.0.1 NO_USE_HASH_AGGREGATION        USE_HASH_AGGREGATION           USE_HASH_AGGREGATION        QKSFM_ALL
10.2.0.1 USE_HASH_AGGREGATION           NO_USE_HASH_AGGREGATION        USE_HASH_AGGREGATION        QKSFM_ALL
10.1.0.3 FBTSCAN                                                       FBTSCAN                     QKSFM_CBO
10.1.0.3 GATHER_PLAN_STATISTICS                                        GATHER_PLAN_STATISTICS      QKSFM_GATHER_PLAN_STATISTICS
10.1.0.3 IGNORE_OPTIM_EMBEDDED_HINTS                                   IGNORE_OPTIM_EMBEDDED_HINTS QKSFM_ALL
10.1.0.3 INCLUDE_VERSION                                               INCLUDE_VERSION             QKSFM_ALL
10.1.0.3 MODEL_DONTVERIFY_UNIQUENESS                                   MODEL_DONTVERIFY_UNIQUENESS QKSFM_TRANSFORMATION
10.1.0.3 MODEL_MIN_ANALYSIS                                            MODEL_MIN_ANALYSIS          QKSFM_TRANSFORMATION
10.1.0.3 MODEL_NO_ANALYSIS                                             MODEL_MIN_ANALYSIS          QKSFM_ALL
10.1.0.3 MODEL_PUSH_REF                 NO_MODEL_PUSH_REF              MODEL_PUSH_REF              QKSFM_TRANSFORMATION
10.1.0.3 NO_MODEL_PUSH_REF              MODEL_PUSH_REF                 MODEL_PUSH_REF              QKSFM_ALL
10.1.0.3 NESTED_TABLE_FAST_INSERT                                      NESTED_TABLE_FAST_INSERT    QKSFM_ALL
10.1.0.3 NO_INDEX_FFS                   INDEX_FFS                      NO_INDEX_FFS                QKSFM_INDEX_FFS
10.1.0.3 NO_INDEX_SS                    INDEX_SS                       NO_INDEX_SS                 QKSFM_INDEX_SS
10.1.0.3 NO_PARTIAL_COMMIT                                             NO_PARTIAL_COMMIT           QKSFM_CBO
10.1.0.3 NO_QUERY_TRANSFORMATION                                       NO_QUERY_TRANSFORMATION     QKSFM_TRANSFORMATION
10.1.0.3 NO_USE_HASH                    USE_HASH                       NO_USE_HASH                 QKSFM_USE_HASH
10.1.0.3 NO_USE_MERGE                   USE_MERGE                      NO_USE_MERGE                QKSFM_USE_MERGE
10.1.0.3 NO_USE_NL                      USE_NL                         NO_USE_NL                   QKSFM_USE_NL
10.1.0.3 OPAQUE_TRANSFORM                                              OPAQUE_TRANSFORM            QKSFM_TRANSFORMATION
10.1.0.3 OPAQUE_XCANONICAL                                             OPAQUE_XCANONICAL           QKSFM_TRANSFORMATION
10.1.0.3 OPTIMIZER_FEATURES_ENABLE                                     OPTIMIZER_FEATURES_ENABLE   QKSFM_ALL
10.1.0.3 OPT_ESTIMATE                                                  OPT_ESTIMATE                QKSFM_OPT_ESTIMATE
10.1.0.3 QB_NAME                                                       QB_NAME                     QKSFM_ALL
10.1.0.3 RESTRICT_ALL_REF_CONS                                         RESTRICT_ALL_REF_CONS       QKSFM_ALL
10.1.0.3 NO_BASETABLE_MULTIMV_REWRITE   REWRITE                        REWRITE                     QKSFM_ALL
10.1.0.3 NO_MULTIMV_REWRITE             REWRITE                        REWRITE                     QKSFM_ALL
10.1.0.3 REWRITE_OR_ERROR                                              REWRITE                     QKSFM_TRANSFORMATION
10.1.0.3 NO_SET_TO_JOIN                 SET_TO_JOIN                    SET_TO_JOIN                 QKSFM_SET_TO_JOIN
10.1.0.3 SET_TO_JOIN                    NO_SET_TO_JOIN                 SET_TO_JOIN                 QKSFM_SET_TO_JOIN
10.1.0.3 NO_PARALLEL                    SHARED                         SHARED                      QKSFM_CBO
10.1.0.3 SKIP_UNQ_UNUSABLE_IDX                                         SKIP_UNQ_UNUSABLE_IDX       QKSFM_CBO
10.1.0.3 NO_STAR_TRANSFORMATION         STAR_TRANSFORMATION            STAR_TRANSFORMATION         QKSFM_STAR_TRANS
10.1.0.3 STREAMS                                                       STREAMS                     QKSFM_CBO
10.1.0.3 NO_SWAP_JOIN_INPUTS            SWAP_JOIN_INPUTS               SWAP_JOIN_INPUTS            QKSFM_CBO
10.1.0.3 COLUMN_STATS                                                  TABLE_STATS                 QKSFM_STATS
10.1.0.3 INDEX_STATS                                                   TABLE_STATS                 QKSFM_STATS
10.1.0.3 TABLE_STATS                                                   TABLE_STATS                 QKSFM_STATS
10.1.0.3 TRACING                                                       TRACING                     QKSFM_EXECUTION
10.1.0.3 USE_NL_WITH_INDEX              NO_USE_NL                      USE_NL_WITH_INDEX           QKSFM_USE_NL_WITH_INDEX
10.1.0.3 USE_WEAK_NAME_RESL                                            USE_WEAK_NAME_RESL          QKSFM_ALL
10.1.0.3 VECTOR_READ                                                   VECTOR_READ                 QKSFM_CBO
10.1.0.3 VECTOR_READ_TRACE                                             VECTOR_READ_TRACE           QKSFM_CBO
10.1.0.3 X_DYN_PRUNE                                                   X_DYN_PRUNE                 QKSFM_CBO
9.2.0    DYNAMIC_SAMPLING                                              DYNAMIC_SAMPLING            QKSFM_DYNAMIC_SAMPLING
9.2.0    DYNAMIC_SAMPLING_EST_CDN                                      DYNAMIC_SAMPLING_EST_CDN    QKSFM_DYNAMIC_SAMPLING_EST_CDN
9.2.0    EXPAND_GSET_TO_UNION           NO_EXPAND_GSET_TO_UNION        EXPAND_GSET_TO_UNION        QKSFM_TRANSFORMATION
9.2.0    NO_EXPAND_GSET_TO_UNION        EXPAND_GSET_TO_UNION           EXPAND_GSET_TO_UNION        QKSFM_TRANSFORMATION
9.2.0    FORCE_XML_QUERY_REWRITE        NO_XML_QUERY_REWRITE           FORCE_XML_QUERY_REWRITE     QKSFM_XML_REWRITE
9.2.0    NO_XML_QUERY_REWRITE           FORCE_XML_QUERY_REWRITE        FORCE_XML_QUERY_REWRITE     QKSFM_XML_REWRITE
9.2.0    IGNORE_WHERE_CLAUSE                                           IGNORE_WHERE_CLAUSE         QKSFM_ALL
9.2.0    NO_QKN_BUFF                                                   NO_QKN_BUFF                 QKSFM_CBO
9.2.0    NO_PUSH_SUBQ                   PUSH_SUBQ                      PUSH_SUBQ                   QKSFM_TRANSFORMATION
9.2.0    NO_REF_CASCADE                 REF_CASCADE_CURSOR             REF_CASCADE_CURSOR          QKSFM_CBO
9.2.0    REF_CASCADE_CURSOR             NO_REF_CASCADE                 REF_CASCADE_CURSOR          QKSFM_CBO
9.2.0    SYS_DL_CURSOR                                                 SYS_DL_CURSOR               QKSFM_CBO
9.2.0    SYS_RID_ORDER                                                 SYS_RID_ORDER               QKSFM_ALL
9.0.0    INDEX_RRS                                                     ACCESS                      QKSFM_CBO
9.0.0    INDEX_SS                       NO_INDEX_SS                    ACCESS                      QKSFM_INDEX_SS
9.0.0    INDEX_SS_ASC                   NO_INDEX_SS                    ACCESS                      QKSFM_INDEX_SS_ASC
9.0.0    INDEX_SS_DESC                  NO_INDEX_SS                    ACCESS                      QKSFM_INDEX_SS_DESC
9.0.0    ANTIJOIN                                                      ANTIJOIN                    QKSFM_TRANSFORMATION
9.0.0    BYPASS_RECURSIVE_CHECK                                        BYPASS_RECURSIVE_CHECK      QKSFM_ALL
9.0.0    CARDINALITY                                                   CARDINALITY                 QKSFM_STATS
9.0.0    CPU_COSTING                    NO_CPU_COSTING                 CPU_COSTING                 QKSFM_CPU_COSTING
9.0.0    NO_CPU_COSTING                 CPU_COSTING                    CPU_COSTING                 QKSFM_CPU_COSTING
9.0.0    CURSOR_SHARING_EXACT                                          CURSOR_SHARING_EXACT        QKSFM_CBO
9.0.0    DML_UPDATE                                                    DML_UPDATE                  QKSFM_CBO
9.0.0    GBY_CONC_ROLLUP                                               GBY_CONC_ROLLUP             QKSFM_TRANSFORMATION
9.0.0    HWM_BROKERED                                                  HWM_BROKERED                QKSFM_CBO
9.0.0    INLINE                         MATERIALIZE                    INLINE                      QKSFM_TRANSFORMATION
9.0.0    MATERIALIZE                    INLINE                         INLINE                      QKSFM_TRANSFORMATION
9.0.0    LOCAL_INDEXES                                                 LOCAL_INDEXES               QKSFM_CBO
9.0.0    MV_MERGE                                                      MV_MERGE                    QKSFM_TRANSFORMATION
9.0.0    NO_PRUNE_GSETS                                                NO_PRUNE_GSETS              QKSFM_TRANSFORMATION
9.0.0    OVERFLOW_NOMOVE                                               OVERFLOW_NOMOVE             QKSFM_CBO
9.0.0    PQ_MAP                         PQ_NOMAP                       PQ_MAP                      QKSFM_PQ_MAP
9.0.0    PQ_NOMAP                       PQ_MAP                         PQ_MAP                      QKSFM_PQ_MAP
9.0.0    NO_SEMIJOIN                    SEMIJOIN                       SEMIJOIN                    QKSFM_TRANSFORMATION
9.0.0    SEMIJOIN                       NO_SEMIJOIN                    SEMIJOIN                    QKSFM_TRANSFORMATION
9.0.0    SKIP_EXT_OPTIMIZER                                            SKIP_EXT_OPTIMIZER          QKSFM_CBO
9.0.0    SQLLDR                                                        SQLLDR                      QKSFM_CBO
9.0.0    USE_TTT_FOR_GSETS                                             USE_TTT_FOR_GSETS           QKSFM_TRANSFORMATION
8.1.6    LEADING                                                       LEADING                     QKSFM_JOIN_ORDER
8.1.6    SYS_PARALLEL_TXN                                              SYS_PARALLEL_TXN            QKSFM_CBO
8.1.6    NO_UNNEST                      UNNEST                         UNNEST                      QKSFM_UNNEST
8.1.6    UNNEST                         NO_UNNEST                      UNNEST                      QKSFM_UNNEST
8.1.5    INDEX_JOIN                                                    ACCESS                      QKSFM_INDEX_JOIN
8.1.5    BUFFER                         NO_BUFFER                      BUFFER                      QKSFM_CBO
8.1.5    NO_BUFFER                      BUFFER                         BUFFER                      QKSFM_CBO
8.1.5    BYPASS_UJVC                                                   BYPASS_UJVC                 QKSFM_CBO
8.1.5    CACHE_CB                       NOCACHE                        CACHE_CB                    QKSFM_CBO
8.1.5    CUBE_GB                                                       CUBE_GB                     QKSFM_CBO
8.1.5    DOMAIN_INDEX_NO_SORT           DOMAIN_INDEX_SORT              DOMAIN_INDEX_SORT           QKSFM_CBO
8.1.5    DOMAIN_INDEX_SORT              DOMAIN_INDEX_NO_SORT           DOMAIN_INDEX_SORT           QKSFM_CBO
8.1.5    NESTED_TABLE_SET_SETID                                        NESTED_TABLE_SET_SETID      QKSFM_ALL
8.1.5    NO_ACCESS                                                     NO_ACCESS                   QKSFM_ALL
8.1.5    NO_INDEX                       INDEX                          NO_INDEX                    QKSFM_INDEX
8.1.5    PQ_DISTRIBUTE                                                 PQ_DISTRIBUTE               QKSFM_PQ_DISTRIBUTE
8.1.5    RESTORE_AS_INTERVALS                                          RESTORE_AS_INTERVALS        QKSFM_CBO
8.1.5    NO_REWRITE                     REWRITE                        REWRITE                     QKSFM_TRANSFORMATION
8.1.5    REWRITE                        NO_REWRITE                     REWRITE                     QKSFM_TRANSFORMATION
8.1.5    SAVE_AS_INTERVALS                                             SAVE_AS_INTERVALS           QKSFM_CBO
8.1.5    SCN_ASCENDING                                                 SCN_ASCENDING               QKSFM_ALL
8.1.0    AND_EQUAL                                                     ACCESS                      QKSFM_AND_EQUAL
8.1.0    FULL                                                          ACCESS                      QKSFM_FULL
8.1.0    HASH                                                          ACCESS                      QKSFM_ALL
8.1.0    INDEX_ASC                      NO_INDEX                       ACCESS                      QKSFM_INDEX_ASC
8.1.0    INDEX_COMBINE                                                 ACCESS                      QKSFM_INDEX_COMBINE
8.1.0    INDEX_DESC                     NO_INDEX                       ACCESS                      QKSFM_INDEX_DESC
8.1.0    INDEX_FFS                                                     ACCESS                      QKSFM_INDEX_FFS
8.1.0    HASH_AJ                                                       ANTIJOIN                    QKSFM_JOIN_METHOD
8.1.0    MERGE_AJ                                                      ANTIJOIN                    QKSFM_JOIN_METHOD
8.1.0    APPEND                         NOAPPEND                       APPEND                      QKSFM_CBO
8.1.0    NOAPPEND                       APPEND                         APPEND                      QKSFM_CBO
8.1.0    BITMAP                                                        BITMAP                      QKSFM_CBO
8.1.0    CACHE                          NOCACHE                        CACHE                       QKSFM_EXECUTION
8.1.0    NOCACHE                        CACHE                          CACHE                       QKSFM_EXECUTION
8.1.0    DEREF_NO_REWRITE                                              DEREF_NO_REWRITE            QKSFM_ALL
8.1.0    DRIVING_SITE                                                  DRIVING_SITE                QKSFM_ALL
8.1.0    FACT                           NO_FACT                        FACT                        QKSFM_STAR_TRANS
8.1.0    NO_FACT                        FACT                           FACT                        QKSFM_STAR_TRANS
8.1.0    USE_HASH                       NO_USE_HASH                    JOIN                        QKSFM_USE_HASH
8.1.0    USE_MERGE                      NO_USE_MERGE                   JOIN                        QKSFM_USE_MERGE
8.1.0    USE_NL                         NO_USE_NL                      JOIN                        QKSFM_USE_NL
8.1.0    MERGE                          NO_MERGE                       MERGE                       QKSFM_CVM
8.1.0    ALL_ROWS                                                      MODE                        QKSFM_ALL_ROWS
8.1.0    CHOOSE                                                        MODE                        QKSFM_CHOOSE
8.1.0    FIRST_ROWS                                                    MODE                        QKSFM_FIRST_ROWS
8.1.0    RULE                                                          MODE                        QKSFM_RBO
8.1.0    NESTED_TABLE_GET_REFS                                         NESTED_TABLE_GET_REFS       QKSFM_ALL
8.1.0    ORDERED                                                       ORDERED                     QKSFM_CBO
8.1.0    NO_EXPAND                      USE_CONCAT                     OR_EXPAND                   QKSFM_USE_CONCAT
8.1.0    USE_CONCAT                     NO_EXPAND                      OR_EXPAND                   QKSFM_USE_CONCAT
8.1.0    NO_PARALLEL_INDEX              PARALLEL_INDEX                 PARALLEL_INDEX              QKSFM_PQ
8.1.0    PARALLEL_INDEX                 NO_PARALLEL_INDEX              PARALLEL_INDEX              QKSFM_PQ
8.1.0    PIV_GB                                                        PIV_GB                      QKSFM_ALL
8.1.0    TIV_GB                                                        PIV_GB                      QKSFM_ALL
8.1.0    PIV_SSF                                                       PIV_SSF                     QKSFM_ALL
8.1.0    TIV_SSF                                                       PIV_SSF                     QKSFM_ALL
8.1.0    NO_PUSH_PRED                   PUSH_PRED                      PUSH_PRED                   QKSFM_FILTER_PUSH_PRED
8.1.0    PUSH_PRED                      NO_PUSH_PRED                   PUSH_PRED                   QKSFM_FILTER_PUSH_PRED
8.1.0    PUSH_SUBQ                      NO_PUSH_SUBQ                   PUSH_SUBQ                   QKSFM_TRANSFORMATION
8.1.0    REMOTE_MAPPED                                                 REMOTE_MAPPED               QKSFM_ALL
8.1.0    HASH_SJ                                                       SEMIJOIN                    QKSFM_JOIN_METHOD
8.1.0    MERGE_SJ                                                      SEMIJOIN                    QKSFM_JOIN_METHOD
8.1.0    SEMIJOIN_DRIVER                                               SEMIJOIN_DRIVER             QKSFM_CBO
8.1.0    NOPARALLEL                     SHARED                         SHARED                      QKSFM_PARALLEL
8.1.0    SHARED                         NO_PARALLEL                    SHARED                      QKSFM_PARALLEL
8.1.0    STAR                                                          STAR                        QKSFM_STAR_TRANS
8.1.0    STAR_TRANSFORMATION            NO_STAR_TRANSFORMATION         STAR_TRANSFORMATION         QKSFM_STAR_TRANS
8.1.0    SWAP_JOIN_INPUTS               NO_SWAP_JOIN_INPUTS            SWAP_JOIN_INPUTS            QKSFM_CBO
8.1.0    USE_ANTI                                                      USE_ANTI                    QKSFM_CBO
8.1.0    USE_SEMI                                                      USE_SEMI                    QKSFM_CBO
8.0.0    CLUSTER                                                       ACCESS                      QKSFM_CBO
8.0.0    INDEX                          NO_INDEX                       ACCESS                      QKSFM_INDEX
8.0.0    QUEUE_CURR                                                    ACCESS                      QKSFM_CBO
8.0.0    QUEUE_ROWP                                                    ACCESS                      QKSFM_CBO
8.0.0    ROWID                                                         ACCESS                      QKSFM_CBO
8.0.0    NL_AJ                                                         ANTIJOIN                    QKSFM_JOIN_METHOD
8.0.0    EXPR_CORR_CHECK                                               EXPR_CORR_CHECK             QKSFM_CBO
8.0.0    NO_MERGE                       MERGE                          MERGE                       QKSFM_CVM
8.0.0    MERGE_CONST_ON                                                MERGE_CONST_ON              QKSFM_CBO
8.0.0    NO_MONITORING                                                 NO_MONITORING               QKSFM_ALL
8.0.0    NO_ORDER_ROLLUPS                                              NO_ORDER_ROLLUPS            QKSFM_TRANSFORMATION
8.0.0    NO_STATS_GSETS                                                NO_STATS_GSETS              QKSFM_ALL
8.0.0    ORDERED_PREDICATES                                            ORDERED_PREDICATES          QKSFM_CBO
8.0.0    NL_SJ                                                         SEMIJOIN                    QKSFM_JOIN_METHOD

373 rows selected.

SYSTEM@pdb1> 

Reference

Best Practices for Gathering Optimizer Statistics with Oracle Database 12c Release 2

Have a good work&life! 2021/07 via LinHong


Similar Posts

Comments