Like every new DB version, with new features there are also new hints in V$SQL_HINT.
In 23c free, there are "only" 16 new hints (compared to 21.9) - and of course, they are not in the documentation (yet).
| NAME | SQL_FEATURE | CLASS | TARGET_LEVEL | PROPERTY | VERSION | VERSION_OUTLINE | sql_feature_hierarchy_path |
|---|---|---|---|---|---|---|---|
| CELL_TRACE | QKSFM_ALL | CELL_TRACE | 1 | 256 | 23.1.0 | -> ALL | |
| COMPRESS_IMMEDIATE | QKSFM_EXECUTION | COMPRESS_IMMEDIATE | 1 | 0 | 23.1.0 | ALL -> EXECUTION | |
| JSON_QRYOVERGEN_REWRITE | QKSFM_JSON_REWRITE | JSON_QRYOVERGEN_REWRITE | 2 | 0 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> JSON_REWRITE |
| JSON_REFERENCE_FOR_UPDATE | QKSFM_JSON | JSON_REFERENCE_FOR_UPDATE | 1 | 0 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> JSON |
| MULTI_APPEND | QKSFM_EXECUTION | MULTI_APPEND | 1 | 0 | 23.1.0 | ALL -> EXECUTION | |
| NO_COMPRESS_IMMEDIATE | QKSFM_EXECUTION | COMPRESS_IMMEDIATE | 1 | 0 | 23.1.0 | ALL -> EXECUTION | |
| NO_JSON_QRYOVERGEN_REWRITE | QKSFM_JSON_REWRITE | JSON_QRYOVERGEN_REWRITE | 2 | 0 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> JSON_REWRITE |
| NO_MULTI_APPEND | QKSFM_EXECUTION | MULTI_APPEND | 1 | 0 | 23.1.0 | ALL -> EXECUTION | |
| NO_PUSH_GBY_INTO_UNION_ALL | QKSFM_PUSH_GBY_INTO_UNION_ALL | PUSH_GBY_INTO_UNION_ALL | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> CBO -> CBQT -> PUSH_GBY_INTO_UNION_ALL |
| NO_PUSH_GBY_INTO_UNION_ALL | QKSFM_PUSH_GBY_INTO_UNION_ALL | PUSH_GBY_INTO_UNION_ALL | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> CBQT -> PUSH_GBY_INTO_UNION_ALL |
| NO_SUBGROUP | QKSFM_SUBGROUP | SUBGROUP | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> HEURISTIC -> SUBGROUP |
| NO_SUBSUME | QKSFM_SUBSUME | SUBSUME | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> HEURISTIC -> SUBSUME |
| PUSH_GBY_INTO_UNION_ALL | QKSFM_PUSH_GBY_INTO_UNION_ALL | PUSH_GBY_INTO_UNION_ALL | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> CBQT -> PUSH_GBY_INTO_UNION_ALL |
| PUSH_GBY_INTO_UNION_ALL | QKSFM_PUSH_GBY_INTO_UNION_ALL | PUSH_GBY_INTO_UNION_ALL | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> CBO -> CBQT -> PUSH_GBY_INTO_UNION_ALL |
| SUBGROUP | QKSFM_SUBGROUP | SUBGROUP | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> HEURISTIC -> SUBGROUP |
| SUBSUME | QKSFM_SUBSUME | SUBSUME | 2 | 16 | 23.1.0 | 23.1.0 | ALL -> COMPILATION -> TRANSFORMATION -> HEURISTIC -> SUBSUME |
I did not find anything in the documentation yet, but this might change over time.
No hints were removed.
Keine Kommentare:
Kommentar veröffentlichen