Last active
February 10, 2025 17:46
-
-
Save xtender/0b7a29da522fa7898bf4913a5f0cd8c2 to your computer and use it in GitHub Desktop.
Example how to get all hints not reported by hint_report(hint_usage)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare | |
| procedure test_hint(p_hint varchar2) is | |
| cmd varchar2(200); | |
| begin | |
| cmd:=replace(q'[explain plan set statement_id='{hint}' for select /*+ {hint} */ 1 from dual]','{hint}',p_hint); | |
| execute immediate cmd; | |
| exception when others then | |
| dbms_output.put_line(cmd); | |
| dbms_output.put_line(sqlerrm); | |
| end; | |
| begin | |
| delete from plan_table; | |
| commit; | |
| for r in ( | |
| select name as hint | |
| from v$sql_hint h | |
| where h.name not in ('FBTSCAN') | |
| order by name | |
| ) loop | |
| test_hint(r.hint); | |
| end loop; | |
| end; | |
| / | |
| select p.statement_id | |
| ,x.hint_target | |
| ,x."ERROR(st)" | |
| ,x.h | |
| --,x.xd,x.o,xmlserialize(content x.xd as varchar2(200)) as hint_rep_xml | |
| from plan_table p | |
| ,xmltable( | |
| '/other_xml/hint_usage' | |
| passing xmltype(p.other_xml) | |
| columns | |
| xd xmltype path '.' | |
| ,hint_target varchar2(11) path './*/name()' | |
| ,o varchar2(10) path './*/h/@o' | |
| ,"ERROR(st)" varchar2(10) path './*/h/@st' | |
| ,h varchar2(35) path './/x' | |
| )(+) x | |
| where p.id=1 | |
| order by x.h nulls first,statement_id; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| STATEMENT_ID HINT_TARGET ERROR(st) H | |
| ------------------------------ ----------- ---------- --------------------------------- | |
| APPEND NULL NULL NULL | |
| APPEND_VALUES NULL NULL NULL | |
| AUTO_REOPTIMIZE NULL NULL NULL | |
| AV_CACHE NULL NULL NULL | |
| BIND_AWARE NULL NULL NULL | |
| BUFFER NULL NULL NULL | |
| BYPASS_RECURSIVE_CHECK NULL NULL NULL | |
| BYPASS_UJVC NULL NULL NULL | |
| CHECK_ACL_REWRITE NULL NULL NULL | |
| CLUSTERING NULL NULL NULL | |
| CONTAINERS NULL NULL NULL | |
| COST_XML_QUERY_REWRITE NULL NULL NULL | |
| CUBE_GB NULL NULL NULL | |
| CURRENT_INSTANCE NULL NULL NULL | |
| CURSOR_SHARING_EXACT NULL NULL NULL | |
| DATA_VALIDATE NULL NULL NULL | |
| DBMS_STATS NULL NULL NULL | |
| DEREF_NO_REWRITE NULL NULL NULL | |
| DISABLE_PARALLEL_DML NULL NULL NULL | |
| DML_UPDATE NULL NULL NULL | |
| DOMAIN_INDEX_NO_SORT NULL NULL NULL | |
| DOMAIN_INDEX_SORT NULL NULL NULL | |
| DST_UPGRADE_INSERT_CONV NULL NULL NULL | |
| ENABLE_PARALLEL_DML NULL NULL NULL | |
| EXPAND_GSET_TO_UNION NULL NULL NULL | |
| EXPR_CORR_CHECK NULL NULL NULL | |
| FORCE_XML_QUERY_REWRITE NULL NULL NULL | |
| FRESH_MV NULL NULL NULL | |
| GATHER_OPTIMIZER_STATISTICS NULL NULL NULL | |
| GATHER_PLAN_STATISTICS NULL NULL NULL | |
| GBY_CONC_ROLLUP NULL NULL NULL | |
| HWM_BROKERED NULL NULL NULL | |
| IGNORE_WHERE_CLAUSE NULL NULL NULL | |
| INCLUDE_VERSION NULL NULL NULL | |
| INLINE_XMLTYPE_NT NULL NULL NULL | |
| LOCAL_INDEXES NULL NULL NULL | |
| MEMOPTIMIZE_WRITE NULL NULL NULL | |
| MODEL_COMPILE_SUBQUERY NULL NULL NULL | |
| MODEL_DONTVERIFY_UNIQUENESS NULL NULL NULL | |
| MODEL_DYNAMIC_SUBQUERY NULL NULL NULL | |
| MODEL_MIN_ANALYSIS NULL NULL NULL | |
| MODEL_NO_ANALYSIS NULL NULL NULL | |
| MODEL_PUSH_REF NULL NULL NULL | |
| MONITOR NULL NULL NULL | |
| MV_MERGE NULL NULL NULL | |
| NESTED_TABLE_FAST_INSERT NULL NULL NULL | |
| NESTED_TABLE_GET_REFS NULL NULL NULL | |
| NESTED_TABLE_SET_SETID NULL NULL NULL | |
| NOAPPEND NULL NULL NULL | |
| NO_AUTO_REOPTIMIZE NULL NULL NULL | |
| NO_BIND_AWARE NULL NULL NULL | |
| NO_BUFFER NULL NULL NULL | |
| NO_CHECK_ACL_REWRITE NULL NULL NULL | |
| NO_CLUSTERING NULL NULL NULL | |
| NO_COST_XML_QUERY_REWRITE NULL NULL NULL | |
| NO_DATA_SECURITY_REWRITE NULL NULL NULL | |
| NO_DST_UPGRADE_INSERT_CONV NULL NULL NULL | |
| NO_EXPAND_GSET_TO_UNION NULL NULL NULL | |
| NO_GATHER_OPTIMIZER_STATISTICS NULL NULL NULL | |
| NO_LOAD NULL NULL NULL | |
| NO_MODEL_PUSH_REF NULL NULL NULL | |
| NO_MONITOR NULL NULL NULL | |
| NO_MONITORING NULL NULL NULL | |
| NO_ORDER_ROLLUPS NULL NULL NULL | |
| NO_PARTIAL_COMMIT NULL NULL NULL | |
| NO_PQ_CONCURRENT_UNION NULL NULL NULL | |
| NO_PRUNE_GSETS NULL NULL NULL | |
| NO_PUSH_HAVING_TO_GBY NULL NULL NULL | |
| NO_PX_FAULT_TOLERANCE NULL NULL NULL | |
| NO_QKN_BUFF NULL NULL NULL | |
| NO_REF_CASCADE NULL NULL NULL | |
| NO_REORDER_WIF NULL NULL NULL | |
| NO_RESULT_CACHE NULL NULL NULL | |
| NO_SQL_TUNE NULL NULL NULL | |
| NO_STATEMENT_QUEUING NULL NULL NULL | |
| NO_STATS_GSETS NULL NULL NULL | |
| NO_SUBSTRB_PAD NULL NULL NULL | |
| NO_TRANSFORM_DISTINCT_AGG NULL NULL NULL | |
| NO_USE_DAGG_UNION_ALL_GSETS NULL NULL NULL | |
| NO_USE_HASH_AGGREGATION NULL NULL NULL | |
| NO_USE_HASH_GBY_FOR_DAGGPSHD NULL NULL NULL | |
| NO_USE_HASH_GBY_FOR_PUSHDOWN NULL NULL NULL | |
| NO_USE_INVISIBLE_INDEXES NULL NULL NULL | |
| NO_USE_PARTITION_WISE_DISTINCT NULL NULL NULL | |
| NO_USE_PARTITION_WISE_GBY NULL NULL NULL | |
| NO_USE_PARTITION_WISE_WIF NULL NULL NULL | |
| NO_USE_SCALABLE_GBY_INVDIST NULL NULL NULL | |
| NO_XMLINDEX_REWRITE NULL NULL NULL | |
| NO_XMLINDEX_REWRITE_IN_SELECT NULL NULL NULL | |
| NO_XML_DML_REWRITE NULL NULL NULL | |
| NO_XML_QUERY_REWRITE NULL NULL NULL | |
| OPAQUE_TRANSFORM NULL NULL NULL | |
| OPAQUE_XCANONICAL NULL NULL NULL | |
| OUTLINE NULL NULL NULL | |
| OUTLINE_LEAF NULL NULL NULL | |
| OVERFLOW_NOMOVE NULL NULL NULL | |
| PDB_LOCAL_ONLY NULL NULL NULL | |
| PIV_GB NULL NULL NULL | |
| PIV_SSF NULL NULL NULL | |
| PQ_CONCURRENT_UNION NULL NULL NULL | |
| PRECOMPUTE_SUBQUERY NULL NULL NULL | |
| PRESERVE_OID NULL NULL NULL | |
| PUSH_HAVING_TO_GBY NULL NULL NULL | |
| PX_FAULT_TOLERANCE NULL NULL NULL | |
| RBO_OUTLINE NULL NULL NULL | |
| REF_CASCADE_CURSOR NULL NULL NULL | |
| REORDER_WIF NULL NULL NULL | |
| RESTORE_AS_INTERVALS NULL NULL NULL | |
| RESULT_CACHE NULL NULL NULL | |
| RETRY_ON_ROW_CHANGE NULL NULL NULL | |
| SAVE_AS_INTERVALS NULL NULL NULL | |
| SCN_ASCENDING NULL NULL NULL | |
| SKIP_PROXY NULL NULL NULL | |
| SKIP_UNQ_UNUSABLE_IDX NULL NULL NULL | |
| SQLLDR NULL NULL NULL | |
| SQL_SCOPE NULL NULL NULL | |
| STATEMENT_QUEUING NULL NULL NULL | |
| STREAMS NULL NULL NULL | |
| SUPPRESS_LOAD NULL NULL NULL | |
| SYS_DL_CURSOR NULL NULL NULL | |
| SYS_PARALLEL_TXN NULL NULL NULL | |
| SYS_RID_ORDER NULL NULL NULL | |
| TIV_GB NULL NULL NULL | |
| TIV_SSF NULL NULL NULL | |
| TRANSFORM_DISTINCT_AGG NULL NULL NULL | |
| USE_DAGG_UNION_ALL_GSETS NULL NULL NULL | |
| USE_HASH_AGGREGATION NULL NULL NULL | |
| USE_HASH_GBY_FOR_DAGGPSHD NULL NULL NULL | |
| USE_HASH_GBY_FOR_PUSHDOWN NULL NULL NULL | |
| USE_HIDDEN_PARTITIONS NULL NULL NULL | |
| USE_INVISIBLE_INDEXES NULL NULL NULL | |
| USE_PARTITION_WISE_DISTINCT NULL NULL NULL | |
| USE_PARTITION_WISE_GBY NULL NULL NULL | |
| USE_PARTITION_WISE_WIF NULL NULL NULL | |
| USE_SCALABLE_GBY_INVDIST NULL NULL NULL | |
| USE_TTT_FOR_GSETS NULL NULL NULL | |
| USE_WEAK_NAME_RESL NULL NULL NULL | |
| VECTOR_READ NULL NULL NULL | |
| VECTOR_READ_TRACE NULL NULL NULL | |
| WITH_PLSQL NULL NULL NULL | |
| XMLINDEX_REWRITE NULL NULL NULL | |
| XMLINDEX_REWRITE_IN_SELECT NULL NULL NULL | |
| XMLINDEX_SEL_IDX_TBL NULL NULL NULL | |
| XMLTSET_DML_ENABLE NULL NULL NULL | |
| XML_DML_RWT_STMT NULL NULL NULL | |
| X_DYN_PRUNE NULL NULL NULL | |
| ADAPTIVE_PLAN s NU ADAPTIVE_PLAN | |
| ALL_ROWS s NULL ALL_ROWS | |
| AND_EQUAL q PE AND_EQUAL | |
| ANSI_REARCH q NU ANSI_REARCH | |
| ANSWER_QUERY_USING_STATS q NU ANSWER_QUERY_USING_STATS | |
| ANTIJOIN q NU ANTIJOIN | |
| BATCH_TABLE_ACCESS_BY_ROWID q PE BATCH_TABLE_ACCESS_BY_ROWID | |
| BITMAP q PE BITMAP | |
| BITMAP_AND q PE BITMAP_AND | |
| BITMAP_TREE q PE BITMAP_TREE | |
| BUSHY_JOIN q NU BUSHY_JOIN | |
| CACHE q PE CACHE | |
| CACHE_CB q PE CACHE_CB | |
| CARDINALITY q PE CARDINALITY | |
| CHANGE_DUPKEY_ERROR_INDEX q PE CHANGE_DUPKEY_ERROR_INDEX | |
| CHOOSE s NULL CHOOSE | |
| CLUSTER q PE CLUSTER | |
| CLUSTER_BY_ROWID q PE CLUSTER_BY_ROWID | |
| COALESCE_SQ q NU COALESCE_SQ | |
| COLUMN_STATS q PE COLUMN_STATS | |
| CONNECT_BY_CB_WHR_ONLY q NU CONNECT_BY_CB_WHR_ONLY | |
| CONNECT_BY_COMBINE_SW q NU CONNECT_BY_COMBINE_SW | |
| CONNECT_BY_COST_BASED q NU CONNECT_BY_COST_BASED | |
| CONNECT_BY_ELIM_DUPS q NU CONNECT_BY_ELIM_DUPS | |
| CONNECT_BY_FILTERING q NU CONNECT_BY_FILTERING | |
| CPU_COSTING q NULL CPU_COSTING | |
| CUBE_AJ q NU CUBE_AJ | |
| CUBE_SJ q NU CUBE_SJ | |
| DATA_SECURITY_REWRITE_LIMIT q PE DATA_SECURITY_REWRITE_LIMIT | |
| DB_VERSION q PE DB_VERSION | |
| DECORRELATE q NU DECORRELATE | |
| DIST_AGG_PROLLUP_PUSHDOWN q NU DIST_AGG_PROLLUP_PUSHDOWN | |
| DOMAIN_INDEX_FILTER q PE DOMAIN_INDEX_FILTER | |
| DRIVING_SITE q PE DRIVING_SITE | |
| DYNAMIC_SAMPLING q PE DYNAMIC_SAMPLING | |
| DYNAMIC_SAMPLING_EST_CDN q PE DYNAMIC_SAMPLING_EST_CDN | |
| ELIMINATE_JOIN q PE ELIMINATE_JOIN | |
| ELIMINATE_OBY q NU ELIMINATE_OBY | |
| ELIMINATE_SQ q NU ELIMINATE_SQ | |
| ELIM_GROUPBY q NU ELIM_GROUPBY | |
| EXPAND_TABLE q PE EXPAND_TABLE | |
| FACT q PE FACT | |
| FACTORIZE_JOIN q NU FACTORIZE_JOIN | |
| FIRST_ROWS s NULL FIRST_ROWS | |
| FULL q PE FULL | |
| FULL_OUTER_JOIN_TO_OUTER q PE FULL_OUTER_JOIN_TO_OUTER | |
| GBY_PUSHDOWN q NU GBY_PUSHDOWN | |
| HASH q PE HASH | |
| HASH_AJ q NU HASH_AJ | |
| HASH_SJ q NU HASH_SJ | |
| IGNORE_OPTIM_EMBEDDED_HINTS s NULL IGNORE_OPTIM_EMBEDDED_HINTS | |
| IGNORE_ROW_ON_DUPKEY_INDEX q PE IGNORE_ROW_ON_DUPKEY_INDEX | |
| INDEX q PE INDEX | |
| INDEX_ASC q PE INDEX_ASC | |
| INDEX_COMBINE q PE INDEX_COMBINE | |
| INDEX_DESC q PE INDEX_DESC | |
| INDEX_FFS q PE INDEX_FFS | |
| INDEX_JOIN q PE INDEX_JOIN | |
| INDEX_RRS q PE INDEX_RRS | |
| INDEX_RS_ASC q PE INDEX_RS_ASC | |
| INDEX_RS_DESC q PE INDEX_RS_DESC | |
| INDEX_SS q PE INDEX_SS | |
| INDEX_SS_ASC q PE INDEX_SS_ASC | |
| INDEX_SS_DESC q PE INDEX_SS_DESC | |
| INDEX_STATS q PE INDEX_STATS | |
| INLINE q NULL INLINE | |
| INMEMORY q NU INMEMORY | |
| INMEMORY_PRUNING q NU INMEMORY_PRUNING | |
| JSON_LENGTH q PE JSON_LENGTH | |
| LEADING q PE LEADING | |
| MATERIALIZE q NULL MATERIALIZE | |
| MERGE q NULL MERGE | |
| MERGE_AJ q NU MERGE_AJ | |
| MERGE_CONST_ON q PE MERGE_CONST_ON | |
| MERGE_SJ q NU MERGE_SJ | |
| NATIVE_FULL_OUTER_JOIN q NU NATIVE_FULL_OUTER_JOIN | |
| NLJ_BATCHING q PE NLJ_BATCHING | |
| NLJ_PREFETCH q PE NLJ_PREFETCH | |
| NL_AJ q NU NL_AJ | |
| NL_SJ q NU NL_SJ | |
| NOCACHE q PE NOCACHE | |
| NOPARALLEL s NU NOPARALLEL | |
| NO_ACCESS q PE NO_ACCESS | |
| NO_ADAPTIVE_PLAN s NULL NO_ADAPTIVE_PLAN | |
| NO_ANSI_REARCH q NULL NO_ANSI_REARCH | |
| NO_ANSWER_QUERY_USING_STATS q NULL NO_ANSWER_QUERY_USING_STATS | |
| NO_BASETABLE_MULTIMV_REWRITE q NULL NO_BASETABLE_MULTIMV_REWRITE | |
| NO_BATCH_TABLE_ACCESS_BY_ROWID q PE NO_BATCH_TABLE_ACCESS_BY_ROWID | |
| NO_BUSHY_JOIN q NULL NO_BUSHY_JOIN | |
| NO_CARTESIAN q PE NO_CARTESIAN | |
| NO_CLUSTER_BY_ROWID q PE NO_CLUSTER_BY_ROWID | |
| NO_COALESCE_SQ q NULL NO_COALESCE_SQ | |
| NO_CONNECT_BY_CB_WHR_ONLY q NULL NO_CONNECT_BY_CB_WHR_ONLY | |
| NO_CONNECT_BY_COMBINE_SW q NULL NO_CONNECT_BY_COMBINE_SW | |
| NO_CONNECT_BY_COST_BASED q NULL NO_CONNECT_BY_COST_BASED | |
| NO_CONNECT_BY_ELIM_DUPS q NULL NO_CONNECT_BY_ELIM_DUPS | |
| NO_CONNECT_BY_FILTERING q NULL NO_CONNECT_BY_FILTERING | |
| NO_CPU_COSTING q NULL NO_CPU_COSTING | |
| NO_DECORRELATE q NULL NO_DECORRELATE | |
| NO_DIST_AGG_PROLLUP_PUSHDOWN q NULL NO_DIST_AGG_PROLLUP_PUSHDOWN | |
| NO_DOMAIN_INDEX_FILTER q PE NO_DOMAIN_INDEX_FILTER | |
| NO_ELIMINATE_JOIN q PE NO_ELIMINATE_JOIN | |
| NO_ELIMINATE_OBY q NULL NO_ELIMINATE_OBY | |
| NO_ELIMINATE_SQ q NULL NO_ELIMINATE_SQ | |
| NO_ELIM_GROUPBY q NULL NO_ELIM_GROUPBY | |
| NO_EXPAND q NULL NO_EXPAND | |
| NO_EXPAND_TABLE q PE NO_EXPAND_TABLE | |
| NO_FACT q PE NO_FACT | |
| NO_FACTORIZE_JOIN q NULL NO_FACTORIZE_JOIN | |
| NO_FULL_OUTER_JOIN_TO_OUTER q PE NO_FULL_OUTER_JOIN_TO_OUTER | |
| NO_GBY_PUSHDOWN q NULL NO_GBY_PUSHDOWN | |
| NO_INDEX q PE NO_INDEX | |
| NO_INDEX_FFS q PE NO_INDEX_FFS | |
| NO_INDEX_SS q PE NO_INDEX_SS | |
| NO_INMEMORY q NULL NO_INMEMORY | |
| NO_INMEMORY_PRUNING q NULL NO_INMEMORY_PRUNING | |
| NO_MERGE q NU NO_MERGE | |
| NO_MULTIMV_REWRITE q NULL NO_MULTIMV_REWRITE | |
| NO_NATIVE_FULL_OUTER_JOIN q NULL NO_NATIVE_FULL_OUTER_JOIN | |
| NO_NLJ_BATCHING q PE NO_NLJ_BATCHING | |
| NO_NLJ_PREFETCH q PE NO_NLJ_PREFETCH | |
| NO_OR_EXPAND q NULL NO_OR_EXPAND | |
| NO_OUTER_JOIN_TO_ANTI q PE NO_OUTER_JOIN_TO_ANTI | |
| NO_OUTER_JOIN_TO_INNER q NULL NO_OUTER_JOIN_TO_INNER | |
| NO_PARALLEL s NU NO_PARALLEL | |
| NO_PARALLEL_INDEX q PE NO_PARALLEL_INDEX | |
| NO_PARTIAL_JOIN q PE NO_PARTIAL_JOIN | |
| NO_PARTIAL_ROLLUP_PUSHDOWN q NULL NO_PARTIAL_ROLLUP_PUSHDOWN | |
| NO_PLACE_DISTINCT q NULL NO_PLACE_DISTINCT | |
| NO_PLACE_GROUP_BY q NULL NO_PLACE_GROUP_BY | |
| NO_PQ_EXPAND_TABLE q PE NO_PQ_EXPAND_TABLE | |
| NO_PQ_REPLICATE q PE NO_PQ_REPLICATE | |
| NO_PQ_SKEW q PE NO_PQ_SKEW | |
| NO_PULL_PRED q PE NO_PULL_PRED | |
| NO_PUSH_PRED q NULL NO_PUSH_PRED | |
| NO_PUSH_SUBQ q NULL NO_PUSH_SUBQ | |
| NO_PX_JOIN_FILTER q PE NO_PX_JOIN_FILTER | |
| NO_QUERY_TRANSFORMATION s NULL NO_QUERY_TRANSFORMATION | |
| NO_REWRITE q NULL NO_REWRITE | |
| NO_SEMIJOIN q NULL NO_SEMIJOIN | |
| NO_SEMI_TO_INNER q PE NO_SEMI_TO_INNER | |
| NO_SET_GBY_PUSHDOWN q NULL NO_SET_GBY_PUSHDOWN | |
| NO_SET_TO_JOIN q NULL NO_SET_TO_JOIN | |
| NO_STAR_TRANSFORMATION q NULL NO_STAR_TRANSFORMATION | |
| NO_SUBQUERY_PRUNING q PE NO_SUBQUERY_PRUNING | |
| NO_SWAP_JOIN_INPUTS q PE NO_SWAP_JOIN_INPUTS | |
| NO_TABLE_LOOKUP_BY_NL q PE NO_TABLE_LOOKUP_BY_NL | |
| NO_UNNEST q NULL NO_UNNEST | |
| NO_USE_CUBE q PE NO_USE_CUBE | |
| NO_USE_HASH q PE NO_USE_HASH | |
| NO_USE_MERGE q PE NO_USE_MERGE | |
| NO_USE_NL q PE NO_USE_NL | |
| NO_USE_VECTOR_AGGREGATION q NULL NO_USE_VECTOR_AGGREGATION | |
| NO_VECTOR_TRANSFORM q NULL NO_VECTOR_TRANSFORM | |
| NO_VECTOR_TRANSFORM_DIMS q PE NO_VECTOR_TRANSFORM_DIMS | |
| NO_VECTOR_TRANSFORM_FACT q PE NO_VECTOR_TRANSFORM_FACT | |
| NO_XDB_FASTPATH_INSERT q PE NO_XDB_FASTPATH_INSERT | |
| NO_ZONEMAP q PE NO_ZONEMAP | |
| NUM_INDEX_KEYS q PE NUM_INDEX_KEYS | |
| OLD_PUSH_PRED q NU OLD_PUSH_PRED | |
| OPTIMIZER_FEATURES_ENABLE q PE OPTIMIZER_FEATURES_ENABLE | |
| OPT_ESTIMATE q PE OPT_ESTIMATE | |
| OPT_PARAM q PE OPT_PARAM | |
| ORDERED q NULL ORDERED | |
| ORDERED_PREDICATES q NULL ORDERED_PREDICATES | |
| ORDER_KEY_VECTOR_USE q PE ORDER_KEY_VECTOR_USE | |
| ORDER_SUBQ q PE ORDER_SUBQ | |
| OR_EXPAND q NU OR_EXPAND | |
| OUTER_JOIN_TO_ANTI q PE OUTER_JOIN_TO_ANTI | |
| OUTER_JOIN_TO_INNER q NU OUTER_JOIN_TO_INNER | |
| PARALLEL_INDEX q PE PARALLEL_INDEX | |
| PARTIAL_JOIN q PE PARTIAL_JOIN | |
| PARTIAL_ROLLUP_PUSHDOWN q NU PARTIAL_ROLLUP_PUSHDOWN | |
| PLACE_DISTINCT q NU PLACE_DISTINCT | |
| PLACE_GROUP_BY q NU PLACE_GROUP_BY | |
| PQ_DISTRIBUTE q PE PQ_DISTRIBUTE | |
| PQ_DISTRIBUTE_WINDOW q PE PQ_DISTRIBUTE_WINDOW | |
| PQ_EXPAND_TABLE q PE PQ_EXPAND_TABLE | |
| PQ_FILTER q PE PQ_FILTER | |
| PQ_MAP q PE PQ_MAP | |
| PQ_NOMAP q PE PQ_NOMAP | |
| PQ_REPLICATE q PE PQ_REPLICATE | |
| PQ_SKEW q PE PQ_SKEW | |
| PULL_PRED q PE PULL_PRED | |
| PUSH_PRED q NU PUSH_PRED | |
| PUSH_SUBQ q NU PUSH_SUBQ | |
| PX_JOIN_FILTER q PE PX_JOIN_FILTER | |
| QB_NAME q PE QB_NAME | |
| QUARANTINE q PE QUARANTINE | |
| QUEUE_CURR q PE QUEUE_CURR | |
| QUEUE_ROWP q PE QUEUE_ROWP | |
| REMOTE_MAPPED q PE REMOTE_MAPPED | |
| RESERVOIR_SAMPLING q PE RESERVOIR_SAMPLING | |
| REWRITE q NU REWRITE | |
| ROWID q PE ROWID | |
| RULE s NULL RULE | |
| SEMIJOIN q NU SEMIJOIN | |
| SEMIJOIN_DRIVER q NULL SEMIJOIN_DRIVER | |
| SEMI_TO_INNER q PE SEMI_TO_INNER | |
| SET_GBY_PUSHDOWN q NU SET_GBY_PUSHDOWN | |
| SET_TO_JOIN q NU SET_TO_JOIN | |
| SHARED s NU SHARED | |
| SKIP_EXT_OPTIMIZER q NULL SKIP_EXT_OPTIMIZER | |
| STAR q NU STAR | |
| STAR_TRANSFORMATION q NU STAR_TRANSFORMATION | |
| SUBQUERY_PRUNING q PE SUBQUERY_PRUNING | |
| SWAP_JOIN_INPUTS q PE SWAP_JOIN_INPUTS | |
| SYSTEM_STATS q PE SYSTEM_STATS | |
| TABLE_LOOKUP_BY_NL q PE TABLE_LOOKUP_BY_NL | |
| TABLE_STATS q PE TABLE_STATS | |
| TRACING q PE TRACING | |
| UNNEST q NU UNNEST | |
| USE_ANTI q PE USE_ANTI | |
| USE_CONCAT q NU USE_CONCAT | |
| USE_CUBE q PE USE_CUBE | |
| USE_HASH q PE USE_HASH | |
| USE_MERGE q PE USE_MERGE | |
| USE_MERGE_CARTESIAN q PE USE_MERGE_CARTESIAN | |
| USE_NL q PE USE_NL | |
| USE_NL_WITH_INDEX q PE USE_NL_WITH_INDEX | |
| USE_SEMI q PE USE_SEMI | |
| USE_VECTOR_AGGREGATION q NU USE_VECTOR_AGGREGATION | |
| VECTOR_TRANSFORM q NU VECTOR_TRANSFORM | |
| VECTOR_TRANSFORM_DIMS q PE VECTOR_TRANSFORM_DIMS | |
| VECTOR_TRANSFORM_FACT q PE VECTOR_TRANSFORM_FACT | |
| XDB_FASTPATH_INSERT q PE XDB_FASTPATH_INSERT | |
| ZONEMAP q PE ZONEMAP | |
| 373 rows selected. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment