# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
1 |
399198 |
1 |
11.2.0.1 |
|
ORDER BY sort elimination with OR expansion |
QKSFM_OR_EXPAND_399198 |
2 |
599680 |
1 |
10.2.0.4 |
|
distinct elimination |
QKSFM_TRANSFORMATION_599680 |
3 |
1403283 |
1 |
8.1.6 |
10135 |
CBO do not count 0 rows partitions |
QKSFM_CBO_1403283 |
4 |
2194204 |
0 |
|
38010 |
disable push predicate driven by func. index into partition view |
QKSFM_TRANSFORMATION_2194204 |
5 |
2320291 |
1 |
9.2.0 |
38017 |
push into table with RLS |
QKSFM_TRANSFORMATION_2320291 |
6 |
2324795 |
1 |
8.1.7 |
38020 |
add(remove) cluster index for push view |
QKSFM_TRANSFORMATION_2324795 |
7 |
2492766 |
1 |
9.2.0 |
|
use OR'ed predicates in index filter |
QKSFM_ACCESS_PATH_2492766 |
8 |
2660592 |
1 |
8.1.7 |
38026 |
do not trigger bitmap plans if no protential domain index driver |
QKSFM_CBO_2660592 |
9 |
2663857 |
1 |
8.0.0 |
38031 |
Use extended index caching discount |
QKSFM_CBO_2663857 |
10 |
3056297 |
1 |
10.1.0 |
|
No selectivity for source transitive equality join predicates |
QKSFM_CBO_3056297 |
11 |
3118776 |
1 |
9.2.0.8 |
38079 |
Check for obj# for named view estimated card |
QKSFM_CBO_3118776 |
12 |
3120429 |
1 |
10.1.0.3 |
|
account for join key sparsity in computing NL index access cost |
QKSFM_ACCESS_PATH_3120429 |
13 |
3151991 |
1 |
10.1.0 |
|
use cost cutoff for first_rows |
QKSFM_FIRST_ROWS_3151991 |
14 |
3320140 |
1 |
10.2.0.5 |
|
IN-List costing problem in index join |
QKSFM_INDEX_JOIN_3320140 |
15 |
3335182 |
1 |
10.2.0.1 |
|
use fkr_1 for (NOT) EXISTS subquery |
QKSFM_ACCESS_PATH_3335182 |
16 |
3426050 |
1 |
10.2.0.1 |
|
Disable cartesian join on complex views |
QKSFM_ACCESS_PATH_3426050 |
17 |
3499674 |
0 |
|
10111 |
enable tiny index improvements: consider small indexes as cachhe |
QKSFM_CBO_3499674 |
18 |
3628118 |
1 |
10.2.0.1 |
|
Do not consider LIKE with leading wildcard as index key |
QKSFM_ACCESS_PATH_3628118 |
19 |
3746511 |
1 |
8.0.0 |
38065 |
do not combine predicates from LNNVL |
QKSFM_CBO_3746511 |
20 |
3801750 |
1 |
8.0.0 |
|
Do not use SQL to check for FK integrity if FK in r/o tablespace |
QKSFM_DML_3801750 |
21 |
3834770 |
1 |
8.0.0 |
|
Lift restriction on unnest subquery with a view |
QKSFM_TRANSFORMATION_3834770 |
22 |
4134994 |
1 |
10.2.0.3 |
|
multiple signatures for selectivity func |
QKSFM_CBO_4134994 |
23 |
4158812 |
1 |
11.1.0.6 |
|
SQ to view transform - remove dual from qbcfro |
QKSFM_TRANSFORMATION_4158812 |
24 |
4168080 |
1 |
11.1.0.6 |
|
Eliminate unneeded bitmap conversion |
QKSFM_SQL_CODE_GENERATOR_4168080 |
25 |
4175830 |
1 |
10.2.0.1 |
|
generate transitive predicates across anti join predicates |
QKSFM_CBO_4175830 |
26 |
4273361 |
1 |
10.2.0.4 |
|
convert range scan to unique access if possible |
QKSFM_CBO_4273361 |
27 |
4279274 |
1 |
11.1.0.6 |
|
Cache user-defined operator stats across transformations |
QKSFM_CBO_4279274 |
28 |
4308414 |
1 |
10.1.0.5 |
38073 |
outer query must have more than one table unless lateral view |
QKSFM_TRANSFORMATION_4308414 |
29 |
4370840 |
1 |
11.1.0.6 |
|
Extend 3628118 to cover peeked binds from cursor_sharing=similar |
QKSFM_ACCESS_PATH_4370840 |
30 |
4386734 |
1 |
11.1.0.6 |
|
f()=f() => f() is not null, selectivity for f() is not null |
QKSFM_CBO_4386734 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
31 |
4444536 |
0 |
|
|
Delayed constant filter node allocation |
QKSFM_COMPILATION_4444536 |
32 |
4483240 |
1 |
9.2.0 |
38082 |
Favor unique index in case of cost tie |
QKSFM_CBO_4483240 |
33 |
4483286 |
0 |
|
38085 |
Discount FFS cost using optimizer_index_cost_adj. |
QKSFM_CBO_4483286 |
34 |
4488689 |
1 |
10.2.0.2 |
38077 |
ignore IS NOT NULL predicate as an index filter |
QKSFM_CBO_4488689 |
35 |
4507997 |
1 |
11.1.0.6 |
|
Eliminate unnessary sort in parallel cartesian merge join |
QKSFM_SQL_CODE_GENERATOR_4507997 |
36 |
4519016 |
1 |
9.2.0 |
38081 |
Pick view card from view qb instead of parent qb |
QKSFM_CBO_4519016 |
37 |
4519340 |
1 |
10.2.0.2 |
|
Generate distinct view in SU if candidate for JPPD |
QKSFM_JPPD_4519340 |
38 |
4545802 |
1 |
10.2.0.4 |
|
Adjust inner card for post filters for outer joins |
QKSFM_CBO_4545802 |
39 |
4545833 |
1 |
10.2.0.2 |
|
no selectivity for transitive inequality predicates |
QKSFM_CBO_4545833 |
40 |
4550003 |
1 |
10.1.0 |
|
do not consider no sel predicates in join selectivity sanity |
QKSFM_CBO_4550003 |
41 |
4554846 |
1 |
10.2.0.2 |
|
tbl$or$idx$part$num() predicate causing peformance problems |
QKSFM_CBO_4554846 |
42 |
4556762 |
15 |
10.2.0.2 |
|
min # of join permutations for starting table, new initial order |
QKSFM_CBO_4556762 |
43 |
4567767 |
1 |
10.2.0.4 |
|
do not re-evaluate density on rowcache reload |
QKSFM_CBO_4567767 |
44 |
4569940 |
1 |
10.1.0.5 |
|
Use index heuristic for join pred being pushed |
QKSFM_JPPD_4569940 |
45 |
4570921 |
1 |
11.2.0.1 |
|
coalesce multiple relational expressions with GREATEST/LEAST |
QKSFM_TRANSFORMATION_4570921 |
46 |
4583239 |
1 |
10.2.0.4 |
|
enable common expr elimination, pred move around for insert stmt |
QKSFM_CBO_4583239 |
47 |
4584065 |
1 |
10.2.0.2 |
|
do not disable cartesian products if ORDERED hint is used |
QKSFM_CBO_4584065 |
48 |
4595987 |
1 |
10.2.0.3 |
|
skip internal ref columns for index only check for update/delete |
QKSFM_CBO_4595987 |
49 |
4600710 |
1 |
10.2.0.3 |
|
Cost inlists as index filters as well as keys |
QKSFM_CBO_4600710 |
50 |
4602374 |
1 |
10.2.0.2 |
|
optimize top-level predicate chain |
QKSFM_CBO_4602374 |
51 |
4605810 |
1 |
10.2.0.4 |
|
apafio - do not set DONE if the matching failed |
QKSFM_ALL_4605810 |
52 |
4611850 |
1 |
10.2.0.2 |
|
do not clobber predicate during first-k row estimate phase |
QKSFM_FIRST_ROWS_4611850 |
53 |
4615392 |
1 |
10.2.0.3 |
|
ANSI syntax prevents table elimination |
QKSFM_TABLE_ELIM_4615392 |
54 |
4619997 |
1 |
10.2.0.4 |
|
enable search of virtual expression in multiple indexes |
QKSFM_ACCESS_PATH_4619997 |
55 |
4631959 |
1 |
10.2.0.2 |
|
Refine criteria for additional phase in JPPD |
QKSFM_JPPD_4631959 |
56 |
4658342 |
1 |
11.1.0.6 |
|
do not push predicates into deeply nested predicate trees |
QKSFM_JPPD_4658342 |
57 |
4663698 |
1 |
10.2.0.2 |
|
for cached NL table set tab_cost_io to zero |
QKSFM_CBO_4663698 |
58 |
4663702 |
1 |
10.2.0.5 |
|
Use base NDV instead of scaled NDV when computing index selectiv |
QKSFM_CBO_4663702 |
59 |
4663804 |
1 |
10.2.0.2 |
|
use smallest table as first table in join card. initial ordering |
QKSFM_CBO_4663804 |
60 |
4666174 |
1 |
11.1.0.6 |
|
consider subqueries for pruning only from optimizer-refined set |
QKSFM_TRANSFORMATION_4666174 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
61 |
4676955 |
1 |
11.1.0.6 |
|
kkojcio: Get view card using kkotbS not kkotbC |
QKSFM_CBO_4676955 |
62 |
4704779 |
1 |
10.2.0.4 |
|
Fix histogram type determination macro |
QKSFM_CBO_4704779 |
63 |
4705343 |
1 |
11.1.0.6 |
|
Relax view merging security checks for SYS PL/SQL functions |
QKSFM_TRANSFORMATION_4705343 |
64 |
4708389 |
1 |
10.2.0.4 |
38078 |
Use inner table and index DOP for costing NL join |
QKSFM_CBO_4708389 |
65 |
4711525 |
1 |
9.2.0 |
38083 |
Enable code optimization for bitmap access path |
QKSFM_CBO_4711525 |
66 |
4716096 |
1 |
10.2.0.4 |
|
Relax view merging security checks for domain indexes |
QKSFM_TRANSFORMATION_4716096 |
67 |
4717546 |
1 |
9.2.0 |
|
avoid semantically redundant predicates to be used |
QKSFM_CBO_4717546 |
68 |
4722900 |
1 |
10.2.0.1 |
|
kkoidc: add SI caching for index branch blocks |
QKSFM_CBO_4722900 |
69 |
4728348 |
1 |
10.2.0.2 |
|
consider mjc if equi-joined pred is dropped in kkoipt |
QKSFM_CBO_4728348 |
70 |
4752814 |
1 |
10.2.0.4 |
|
treat ansi char constant as varchar2 if operator is not ANSI |
QKSFM_CBO_4752814 |
71 |
4768040 |
1 |
11.1.0.6 |
|
Enable CBQT for CTAS statements |
QKSFM_TRANSFORMATION_4768040 |
72 |
4872602 |
0 |
|
|
Disable unnesting of SQ under certain conditions |
QKSFM_TRANSFORMATION_4872602 |
73 |
4878299 |
1 |
10.2.0.4 |
|
FKR: also prorate index ABK (avg blocks per key) |
QKSFM_CBO_4878299 |
74 |
4881533 |
1 |
11.1.0.6 |
|
Limit # of slave groups to DOP |
QKSFM_CBO_4881533 |
75 |
4887636 |
1 |
11.1.0.6 |
|
remove restriction from first K row optimization |
QKSFM_FIRST_ROWS_4887636 |
76 |
4900129 |
1 |
10.2.0.1 |
14199 |
Only use relevant check constraints for transitive pred. generat |
QKSFM_CBO_4900129 |
77 |
4904838 |
1 |
9.2.0.8 |
|
allow index skip scan with no index keys |
QKSFM_CBO_4904838 |
78 |
4904890 |
1 |
10.2.0.3 |
|
do not copy kcc of columns in non-view side of a JPPD |
QKSFM_JPPD_4904890 |
79 |
4908162 |
1 |
10.2.0.3 |
|
Enable star plan for 2 column part pruning index |
QKSFM_CBO_4908162 |
80 |
4924149 |
1 |
10.2.0.4 |
|
Allow secure view merging if outside of view is zero-argument |
QKSFM_TRANSFORMATION_4924149 |
81 |
4926618 |
1 |
11.2.0.2 |
|
do not use hash unique for subqueries in update-set expression |
QKSFM_EXECUTION_4926618 |
82 |
4967068 |
1 |
11.1.0.6 |
|
outer join table elimination |
QKSFM_TABLE_ELIM_4967068 |
83 |
4969880 |
0 |
|
38084 |
upgrade to row-read access instead of row-write |
QKSFM_EXECUTION_4969880 |
84 |
5005866 |
1 |
9.2.0.8 |
|
remove null first element from multicolumn inlist if possible |
QKSFM_CBO_5005866 |
85 |
5014836 |
1 |
10.2.0.1 |
|
Enable CBQT for INSERT statements |
QKSFM_TRANSFORMATION_5014836 |
86 |
5015557 |
1 |
9.2.0 |
|
add new predicate to the VC-EXPR mapping |
QKSFM_TRANSFORMATION_5015557 |
87 |
5029464 |
1 |
9.2.0 |
|
inline view in a stored view |
QKSFM_TRANSFORMATION_5029464 |
88 |
5029592 |
3 |
11.2.0.1 |
|
derive column statistics from a UNION(ALL) view |
QKSFM_CBO_5029592 |
89 |
5084239 |
1 |
10.2.0.3 |
|
try for subqueries before forcing in star trans with FACT hint |
QKSFM_TRANSFORMATION_5084239 |
90 |
5096560 |
1 |
10.2.0.4 |
|
use sql text from qbcqutxt for reparse |
QKSFM_ALL_5096560 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
91 |
5099019 |
0 |
|
|
set leaf blocks to the number of blocks in the index extent map |
QKSFM_DBMS_STATS_5099019 |
92 |
5099909 |
1 |
10.2.0.4 |
|
Consider subquery pruning using view containing single table pre |
QKSFM_CBO_5099909 |
93 |
5104624 |
1 |
10.2.0.3 |
|
multiple signatures for selectivity func |
QKSFM_CBO_5104624 |
94 |
5112260 |
1 |
11.1.0.6 |
|
semi join table elimination |
QKSFM_TABLE_ELIM_5112260 |
95 |
5112352 |
1 |
11.1.0.6 |
|
anti join table elimination |
QKSFM_TABLE_ELIM_5112352 |
96 |
5112460 |
1 |
11.1.0.6 |
|
Make table elimination independent of CVM |
QKSFM_TABLE_ELIM_5112460 |
97 |
5129233 |
1 |
10.2.0.3 |
|
peek at any foldable exprssion during pruning |
QKSFM_CBO_5129233 |
98 |
5139520 |
1 |
11.1.0.6 |
|
kkoDMcos: For PWJ on list dimension, use part/subpart bits |
QKSFM_CBO_5139520 |
99 |
5143477 |
0 |
|
22284 |
disable the fix for the bug # 5011764 |
QKSFM_ALL_5143477 |
100 |
5195882 |
1 |
10.2.0.3 |
|
Enhance view merging security checks for PL/SQL functions |
QKSFM_CBO_5195882 |
101 |
5199213 |
1 |
10.2.0.4 |
|
do not push constant predicate into set query block |
QKSFM_FILTER_PUSH_PRED_5199213 |
102 |
5220356 |
1 |
10.2.0.4 |
|
Allow predicate push for predicates that partition prune |
QKSFM_CBO_5220356 |
103 |
5236908 |
1 |
10.2.0.4 |
|
Allow _optimizer_index_caching to affect IOT primary keys |
QKSFM_ACCESS_PATH_5236908 |
104 |
5240264 |
0 |
|
38086 |
Share single copy of coldef within an expression |
QKSFM_CBO_5240264 |
105 |
5240607 |
1 |
10.2.0.4 |
|
avoid NL with fts on right side in fkr mode |
QKSFM_CBO_5240607 |
106 |
5259048 |
1 |
10.2.0.4 |
|
undo unused inlist |
QKSFM_CBO_5259048 |
107 |
5263572 |
1 |
10.2.0.4 |
|
correct selectivity of col LIKE func(:b1) |
QKSFM_CBO_5263572 |
108 |
5284200 |
0 |
10.2.0.5 |
|
do not merge view with distinct into connect by query block |
QKSFM_SVM_5284200 |
109 |
5288623 |
1 |
10.2.0.4 |
|
also try for sort eliminating index with maximum columns |
QKSFM_ACCESS_PATH_5288623 |
110 |
5302124 |
1 |
10.2.0.4 |
|
Allow CBQT for queries with window functions |
QKSFM_TRANSFORMATION_5302124 |
111 |
5371452 |
1 |
11.1.0.6 |
|
put false predicate ahead in the predicate chain |
QKSFM_CBO_5371452 |
112 |
5383891 |
1 |
11.1.0.6 |
|
Limit join permutations considered to 2000 for star plans |
QKSFM_JOIN_ORDER_5383891 |
113 |
5384335 |
1 |
11.1.0.6 |
|
Add heuristic for group-by placement |
QKSFM_TRANSFORMATION_5384335 |
114 |
5385629 |
1 |
10.2.0.4 |
|
Remove restrictions on unsupported view structures for JPPD |
QKSFM_JPPD_5385629 |
115 |
5387148 |
1 |
10.2.0.4 |
|
Propagate interleaved CVM flag from CBQT analysis |
QKSFM_CBQT_5387148 |
116 |
5391505 |
1 |
10.2.0.4 |
|
add subheap for physical optimization |
QKSFM_CBO_5391505 |
117 |
5391942 |
1 |
10.2.0.5 |
|
Favor rowid= over any other access path regardless of statistics |
QKSFM_ACCESS_PATH_5391942 |
118 |
5394888 |
1 |
10.2.0.5 |
|
don't over-write prorated cardinalities on switch to Amode plan |
QKSFM_FIRST_ROWS_5394888 |
119 |
5395291 |
1 |
11.1.0.6 |
|
prefer index access when joining first non 1-row table in K mode |
QKSFM_FIRST_ROWS_5395291 |
120 |
5396162 |
1 |
10.2.0.4 |
|
Lift restriction on semi-join elimination |
QKSFM_TRANSFORMATION_5396162 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
121 |
5400639 |
1 |
11.2.0.1 |
|
simplification of multiple OR conditions |
QKSFM_TRANSFORMATION_5400639 |
122 |
5406763 |
1 |
10.2.0.5 |
|
use guess quality from secondary index |
QKSFM_ACCESS_PATH_5406763 |
123 |
5416118 |
1 |
8.0.0 |
|
use hash-based mapping in copy service |
QKSFM_CBQT_5416118 |
124 |
5449488 |
1 |
10.2.0.4 |
|
In bitmap costing use real sel for transitive negated predicates |
QKSFM_CBO_5449488 |
125 |
5466973 |
1 |
10.2.0.5 |
|
Do colocate join if columns in fro->frojand are on the same node |
QKSFM_CBO_5466973 |
126 |
5468809 |
1 |
10.2.0.4 |
|
Skip OR chain to enable view merging |
QKSFM_TRANSFORMATION_5468809 |
127 |
5475051 |
1 |
8.0.0 |
|
Wrong results from query with nested table |
QKSFM_TABLE_ELIM_5475051 |
128 |
5482831 |
1 |
10.2.0.4 |
|
discount for partitioned range scan in fkr mode |
QKSFM_TRANSFORMATION_5482831 |
129 |
5483301 |
1 |
10.2.0.4 |
|
Use min repeat count in freq histogram to compute the density |
QKSFM_CBO_5483301 |
130 |
5505157 |
1 |
10.2.0.4 |
|
relax type matching in pre-rewrite transitive predicate generati |
QKSFM_CBO_5505157 |
131 |
5505995 |
1 |
11.1.0.6 |
|
Consider pushing into each of two views sharing join predicate |
QKSFM_JPPD_5505995 |
132 |
5509293 |
1 |
10.2.0.4 |
|
Relax semi/antijoin restrictions with remote tables |
QKSFM_TRANSFORMATION_5509293 |
133 |
5520732 |
1 |
11.2.0.1 |
|
light check of gby validity in subquery |
QKSFM_SVM_5520732 |
134 |
5547058 |
1 |
10.2.0.4 |
|
Promote column min/max values in OJPPD for UNION [ALL] views |
QKSFM_OLD_PUSH_PRED_5547058 |
135 |
5547895 |
1 |
10.2.0.4 |
|
controls generating transitive predicates in presence of UDFs |
QKSFM_CBO_5547895 |
136 |
5554865 |
1 |
11.1.0.6 |
|
Allow inner join table elimination on unique col |
QKSFM_TABLE_ELIM_5554865 |
137 |
5567933 |
1 |
11.1.0.6 |
|
no view with having for group-by placement |
QKSFM_TRANSFORMATION_5567933 |
138 |
5570494 |
1 |
10.2.0.4 |
|
ignore KKOIXMSU flag and match index filter preds with index key |
QKSFM_ACCESS_PATH_5570494 |
139 |
5578791 |
1 |
11.1.0.6 |
|
do not discount branch io cost if inner table io cost is already |
QKSFM_CBO_5578791 |
140 |
5585313 |
1 |
11.1.0.6 |
|
enable index prefetching for NLJ with unique scan as inner acces |
QKSFM_EXECUTION_5585313 |
141 |
5593639 |
1 |
11.1.0.6 |
|
Push USERENV filter predicate into view |
QKSFM_TRANSFORMATION_5593639 |
142 |
5611962 |
1 |
10.2.0.4 |
|
use index keys as filters when considering index min/max |
QKSFM_ACCESS_PATH_5611962 |
143 |
5618040 |
1 |
10.2.0.4 |
|
amend costing for index use to avoid sort with old FIRST_ROWS |
QKSFM_FIRST_ROWS_5618040 |
144 |
5620485 |
1 |
10.2.0.4 |
|
do not push into UV if target table is outer joinded |
QKSFM_OLD_PUSH_PRED_5620485 |
145 |
5624216 |
1 |
10.2.0.4 |
|
disable union all transformation if qbc does not have whr |
QKSFM_CBO_5624216 |
146 |
5634346 |
1 |
10.2.0.4 |
|
Relax equality operator restrictions for multicolumn inlists |
QKSFM_CBO_5634346 |
147 |
5648287 |
3 |
10.2.0.5 |
|
Adjust join cardinality of join backs |
QKSFM_STAR_TRANS_5648287 |
148 |
5650477 |
1 |
10.2.0.4 |
|
set correlation flag if outer col is set func |
QKSFM_CVM_5650477 |
149 |
5657044 |
1 |
11.1.0.6 |
|
consider new alternate index to avoid ORDER BY sort |
QKSFM_CBO_5657044 |
150 |
5680702 |
1 |
10.2.0.4 |
|
adjust anti/semijoin index selectivity only if join preds as key |
QKSFM_ACCESS_PATH_5680702 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
151 |
5694984 |
1 |
10.2.0.4 |
|
scale index num distinct keys with Watkins func in first_rows(k) |
QKSFM_FIRST_ROWS_5694984 |
152 |
5705630 |
0 |
|
|
remove generated single table predicates before OR expansion |
QKSFM_OR_EXPAND_5705630 |
153 |
5707608 |
1 |
11.1.0.6 |
|
do not load statistics for non access partitions |
QKSFM_STATS_5707608 |
154 |
5714944 |
1 |
10.2.0.5 |
|
set IO cost for index skip scan to at least 1.0 |
QKSFM_ACCESS_PATH_5714944 |
155 |
5716785 |
1 |
11.2.0.1 |
38044 |
Peek at systimestamp at compile-time |
QKSFM_CBO_5716785 |
156 |
5741044 |
1 |
10.2.0.4 |
|
consider predicate with subquery when determine 1-row tables |
QKSFM_CBO_5741044 |
157 |
5741121 |
1 |
10.2.0.4 |
|
avoid zero selectivity for negated predicate |
QKSFM_CBO_5741121 |
158 |
5762598 |
1 |
10.2.0.4 |
|
improve selectivity for character strings of numeric data |
QKSFM_CBO_5762598 |
159 |
5838613 |
1 |
10.2.0.4 |
|
Sort tables for initial join order during star transformation |
QKSFM_STAR_TRANS_5838613 |
160 |
5842686 |
0 |
|
38087 |
compute avg col length for LONG RAW column |
QKSFM_STATS_5842686 |
161 |
5844495 |
1 |
10.2.0.4 |
|
Eliminate group-by from [NOT] EXISTS subqueries |
QKSFM_TRANSFORMATION_5844495 |
162 |
5868490 |
1 |
8.0.0 |
|
disallow CVM for top QB views for DELETE |
QKSFM_CVM_5868490 |
163 |
5872956 |
1 |
10.2.0.4 |
|
push constant filter predicates on PRIORs to connect by pump |
QKSFM_EXECUTION_5872956 |
164 |
5882954 |
1 |
10.2.0.4 |
|
Avoid unnecessary column stats load for partitioned tables |
QKSFM_STATS_5882954 |
165 |
5884780 |
1 |
10.2.0.4 |
|
consider list of values dimensions during star transformation |
QKSFM_STAR_TRANS_5884780 |
166 |
5891471 |
1 |
10.2.0.4 |
|
no transitive generation across logical join check constraints |
QKSFM_CBO_5891471 |
167 |
5892599 |
0 |
|
|
disable hash join for NEED1ROW subqueries |
QKSFM_CBO_5892599 |
168 |
5893768 |
1 |
10.2.0.5 |
|
assume final merge not materialized when estimating temp space s |
QKSFM_CBO_5893768 |
169 |
5897486 |
1 |
11.2.0.1 |
|
enable nlj with func-based ix for join to connect by pump (no cb |
QKSFM_EXECUTION_5897486 |
170 |
5902962 |
1 |
10.2.0.5 |
|
Extend push of ROWID filter predicates into views |
QKSFM_CBO_5902962 |
171 |
5909305 |
1 |
8.0.0 |
|
Get SS lock on child(parent) for serial DML on parent(child) |
QKSFM_DML_5909305 |
172 |
5919513 |
1 |
10.2.0.5 |
|
handle virtual columns when comparing row ordering for GBY |
QKSFM_CBO_5919513 |
173 |
5922070 |
1 |
10.2.0.5 |
|
Enable equivalence classes for nested loop join columns |
QKSFM_SORT_ELIM_5922070 |
174 |
5923644 |
1 |
11.1.0.6 |
|
Enable outer to inner join conversion for inlist |
QKSFM_TRANSFORMATION_5923644 |
175 |
5936366 |
1 |
11.1.0.7 |
|
Relax restrictions for SVM with multiply refd scalar subquery |
QKSFM_SVM_5936366 |
176 |
5943234 |
1 |
8.0.0 |
|
Change drop column, set unused to take X DML lock |
QKSFM_TRANSFORMATION_5943234 |
177 |
5944076 |
1 |
10.2.0.4 |
|
make index access more attractive in first_rows(k) |
QKSFM_FIRST_ROWS_5944076 |
178 |
5947231 |
1 |
10.2.0.4 |
|
do not share rowid of gi for multiple objects |
QKSFM_STAR_TRANS_5947231 |
179 |
5949981 |
1 |
10.2.0.4 |
|
amend selectivity for match of a single-row frequency bucket |
QKSFM_CBO_5949981 |
180 |
5976822 |
1 |
10.2.0.4 |
|
check dynamic sampling index selecticity for nested loops join |
QKSFM_ACCESS_PATH_5976822 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
181 |
5982893 |
1 |
11.2.0.2 |
|
compact row vector of colocated join |
QKSFM_SQL_CODE_GENERATOR_5982893 |
182 |
5996801 |
1 |
10.2.0.4 |
|
use subpartition-level statistics |
QKSFM_TABLE_STATS_5996801 |
183 |
6006300 |
1 |
11.1.0.7 |
|
allow JPPD with Cartesian join |
QKSFM_JPPD_6006300 |
184 |
6006457 |
1 |
10.2.0.4 |
|
merge single-table anti-joined view |
QKSFM_TRANSFORMATION_6006457 |
185 |
6007259 |
1 |
10.2.0.4 |
|
Add sort cost only to first OR branch |
QKSFM_OR_EXPAND_6007259 |
186 |
6012093 |
1 |
10.2.0.5 |
|
use nested loops to join to connect by pump if high cardinality |
QKSFM_CBQT_6012093 |
187 |
6020579 |
1 |
11.1.0.6 |
|
Allow semi-join elimination with multi column operand |
QKSFM_TRANSFORMATION_6020579 |
188 |
6029469 |
1 |
10.2.0.5 |
|
Index MIN/MAX capping row sources for range partitioned tables |
QKSFM_SQL_CODE_GENERATOR_6029469 |
189 |
6042205 |
1 |
10.2.0.4 |
|
Do not consider sort-merge to eliminate ORDER BY with no join |
QKSFM_CBO_6042205 |
190 |
6051211 |
1 |
10.2.0.4 |
|
Correction to join cardinality computation for equijoin predicat |
QKSFM_CBO_6051211 |
191 |
6053861 |
0 |
|
|
hide negated predicate when trying full bitmap scan |
QKSFM_ACCESS_PATH_6053861 |
192 |
6055658 |
1 |
11.2.0.3 |
|
reconize empty joins with histograms |
QKSFM_CARDINALITY_6055658 |
193 |
6057611 |
1 |
10.2.0.5 |
|
call kkehsl() if string in LIKE operator does not have wild card |
QKSFM_CBO_6057611 |
194 |
6062266 |
1 |
10.2.0.4 |
|
use density if estimated selectivity is 0 for range predicate |
QKSFM_CARDINALITY_6062266 |
195 |
6070954 |
1 |
10.2.0.4 |
|
No skip scan with contiguous leading equality index keys |
QKSFM_ACCESS_PATH_6070954 |
196 |
6073325 |
1 |
10.2.0.5 |
|
enable connect by cost-based trasnformation for fixed tables |
QKSFM_CBQT_6073325 |
197 |
6082745 |
1 |
10.2.0.4 |
|
Do not prorate out-of-range selectivity for single value hist |
QKSFM_CBO_6082745 |
198 |
6086930 |
1 |
11.2.0.2 |
|
correct skip scan selectivity evaluation for BETWEEN predicate |
QKSFM_ACCESS_PATH_6086930 |
199 |
6087237 |
1 |
10.2.0.4 |
|
do not swap 1 row/leading tables |
QKSFM_ACCESS_PATH_6087237 |
200 |
6119382 |
1 |
10.2.0.5 |
|
no parallel index range scan if single partition is accessed |
QKSFM_ACCESS_PATH_6119382 |
201 |
6119510 |
1 |
11.1.0.6 |
|
Allow JPPD for union-all views with window functions |
QKSFM_JPPD_6119510 |
202 |
6120483 |
1 |
10.2.0.5 |
|
favor index only access over range scan |
QKSFM_CARDINALITY_6120483 |
203 |
6122894 |
1 |
10.2.0.4 |
|
enhance checks for constant filter push into UNION ALL view |
QKSFM_CBO_6122894 |
204 |
6133948 |
1 |
11.1.0.6 |
|
allocate ckydef on the compilation heap |
QKSFM_COMPILATION_6133948 |
205 |
6138746 |
1 |
10.2.0.5 |
|
Consider only simple column preds in subquery unnest heuristic |
QKSFM_ACCESS_PATH_6138746 |
206 |
6141818 |
1 |
11.1.0.6 |
|
Do not timeout when querying rowcache for (sub)partition |
QKSFM_ALL_6141818 |
207 |
6146906 |
1 |
10.2.0.5 |
|
amend fix of bug 3697218 for window func |
QKSFM_TRANSFORMATION_6146906 |
208 |
6151963 |
1 |
10.2.0.4 |
|
estimation of overlap with histograms |
QKSFM_CBO_6151963 |
209 |
6163564 |
1 |
10.2.0.4 |
|
Peek truncated binds under operators for LIKE predicates |
QKSFM_CBO_6163564 |
210 |
6163600 |
1 |
8.0.0 |
|
use NO_SUBSTRB_PAD hint when building histograms |
QKSFM_DBMS_STATS_6163600 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
211 |
6167716 |
1 |
11.1.0.7 |
|
replace primary key references during table elimination |
QKSFM_TABLE_ELIM_6167716 |
212 |
6188881 |
1 |
10.2.0.4 |
|
Amend AJ/SJ index selectivity adjustment |
QKSFM_CBO_6188881 |
213 |
6221403 |
1 |
10.2.0.5 |
|
Fix setting outOfRange indicator in sel. estimation |
QKSFM_CBO_6221403 |
214 |
6236862 |
1 |
11.2.0.2 |
|
account for partition-extended names in first rows optimization |
QKSFM_FIRST_ROWS_6236862 |
215 |
6239039 |
1 |
11.1.0.6 |
|
Allow partition pushup for max/min operators |
QKSFM_PARTITION_6239039 |
216 |
6239909 |
1 |
11.1.0.6 |
|
Fix out-of-bound value in self induced caching |
QKSFM_ACCESS_PATH_6239909 |
217 |
6239971 |
1 |
10.2.0.4 |
|
use density if estimated selectivity is 0 for range predicate |
QKSFM_CARDINALITY_6239971 |
218 |
6251917 |
1 |
10.2.0.4 |
|
Do not apply index caching if no real join access predicates exi |
QKSFM_CBO_6251917 |
219 |
6267621 |
1 |
10.2.0.5 |
|
not use index ndk for selectivity estimation |
QKSFM_ACCESS_PATH_6267621 |
220 |
6279918 |
1 |
11.1.0.6 |
|
Use optimizer_degree to determine SGBY pushdown |
QKSFM_PQ_6279918 |
221 |
6282093 |
1 |
10.2.0.5 |
|
allow OR expansion in start with query block |
QKSFM_CBQT_6282093 |
222 |
6282944 |
1 |
10.2.0.5 |
|
allow pushing predicates from connect by query blocks into views |
QKSFM_CBQT_6282944 |
223 |
6326934 |
1 |
10.2.0.5 |
|
normalize varchar2 const as fixed CHAR if another operand is CHA |
QKSFM_CBO_6326934 |
224 |
6329318 |
1 |
10.2.0.5 |
|
use combined selectivity of range predicates with binds |
QKSFM_CARDINALITY_6329318 |
225 |
6365442 |
1 |
10.2.0.5 |
|
add pflags info into other_xml |
QKSFM_SQL_PLAN_MANAGEMENT_6365442 |
226 |
6368066 |
1 |
11.1.0.7 |
|
Allow broadcast local distribution for ref-partitioning |
QKSFM_PARTITION_6368066 |
227 |
6376551 |
1 |
11.2.0.1 |
|
remove distribution method optimization for insert/update qbc |
QKSFM_PQ_6376551 |
228 |
6377505 |
1 |
11.1.0.7 |
|
Convert outer-join to inner-join if single set aggregate functio |
QKSFM_TRANSFORMATION_6377505 |
229 |
6399597 |
0 |
|
|
disallow HASH GROUP BY for subquery (in filter) processing |
QKSFM_COMPILATION_6399597 |
230 |
6408301 |
1 |
11.2.0.2 |
|
use recursive idx selectivity for partitioned table as well |
QKSFM_DYNAMIC_SAMPLING_6408301 |
231 |
6418552 |
1 |
10.2.0.5 |
|
suppress staleness tracking of non-safe rewrite equivalences |
QKSFM_MVIEWS_6418552 |
232 |
6418771 |
1 |
10.2.0.5 |
|
use equivalence class when trying for order-by sort elimination |
QKSFM_SORT_ELIM_6418771 |
233 |
6429113 |
1 |
10.2.0.5 |
|
no join elimination for start with qb |
QKSFM_TRANSFORMATION_6429113 |
234 |
6430500 |
0 |
|
|
prefer fully qualified unique index even if more expensive |
QKSFM_ACCESS_PATH_6430500 |
235 |
6434668 |
1 |
10.2.0.5 |
|
skip unusable indexes if hinted internally |
QKSFM_ACCESS_PATH_6434668 |
236 |
6438752 |
1 |
11.1.0.7 |
|
do not store cost annotations for branch QBs in unnested subquer |
QKSFM_CBQT_6438752 |
237 |
6438892 |
1 |
11.1.0.7 |
|
selectively apply fkr on views |
QKSFM_CBO_6438892 |
238 |
6439032 |
1 |
11.1.0.6 |
|
Relax index heuristic for JPPD in UNION[ALL] view |
QKSFM_JPPD_6439032 |
239 |
6440977 |
0 |
|
|
No selectivity for some logically redundant predicates |
QKSFM_CBO_6440977 |
240 |
6451322 |
1 |
10.2.0.5 |
|
allow CBQT even if there is a query block inside a having clause |
QKSFM_TRANSFORMATION_6451322 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
241 |
6468287 |
1 |
10.2.0.5 |
|
Remove unnecessary sort when view column refers to const operand |
QKSFM_EXECUTION_6468287 |
242 |
6469667 |
1 |
10.2.0.5 |
|
typecheck pushed predicate to convert decrypt operator |
QKSFM_TRANSFORMATION_6469667 |
243 |
6472966 |
1 |
11.2.0.2 |
|
load and use statistics for hash sub-partitions |
QKSFM_PARTITION_6472966 |
244 |
6502845 |
1 |
11.1.0.7 |
|
enable PWJ on ref-part table and composite parent join |
QKSFM_CBO_6502845 |
245 |
6503543 |
1 |
11.1.0.7 |
|
Improve range join selectivity |
QKSFM_CBO_6503543 |
246 |
6514189 |
1 |
10.2.0.5 |
|
allow merging of view with (+) in OR clause |
QKSFM_TRANSFORMATION_6514189 |
247 |
6520717 |
0 |
|
|
disallow CONNECT BY clauses that use ROWNUM or have no PRIORs |
QKSFM_COMPILATION_6520717 |
248 |
6528872 |
1 |
10.2.0.5 |
|
don't expand NVL(DECODE) with constant second(third) argument |
QKSFM_CBO_6528872 |
249 |
6530596 |
1 |
10.2.0.5 |
|
sort columns by id |
QKSFM_CBO_6530596 |
250 |
6608941 |
0 |
|
|
allow dynamic sampling on fixed tables |
QKSFM_DYNAMIC_SAMPLING_6608941 |
251 |
6610822 |
1 |
10.2.0.5 |
|
allow (+) in OR clause |
QKSFM_CBO_6610822 |
252 |
6612471 |
1 |
11.1.0.7 |
|
cleanup qbciqb after xml rewrite |
QKSFM_XML_REWRITE_6612471 |
253 |
6617866 |
1 |
8.0.0 |
|
ensure outer joined operands are not marked as constant |
QKSFM_COMPILATION_6617866 |
254 |
6626018 |
0 |
|
|
FKR: switch to A mode if leading is FTS |
QKSFM_FIRST_ROWS_6626018 |
255 |
6656356 |
1 |
10.2.0.5 |
|
allow table elimination in presence of join indexes |
QKSFM_TABLE_ELIM_6656356 |
256 |
6669103 |
1 |
10.2.0.5 |
|
an operand of OPTTNN is null-safe for query unnesting |
QKSFM_TRANSFORMATION_6669103 |
257 |
6670551 |
1 |
11.2.0.1 |
|
derive index statistics even if table is empty |
QKSFM_INDEX_STATS_6670551 |
258 |
6671155 |
1 |
10.2.0.5 |
|
Allow join elimination in presence of OR predicate chains |
QKSFM_TABLE_ELIM_6671155 |
259 |
6674254 |
1 |
10.2.0.5 |
|
FKR: apply subquery filtering factor on all-rows cardinality |
QKSFM_FIRST_ROWS_6674254 |
260 |
6681545 |
1 |
11.1.0.7 |
|
Enable unnesting of correlated subquery containing tbl$ predicat |
QKSFM_PARTITION_6681545 |
261 |
6688200 |
1 |
10.2.0.5 |
|
check for log AND before disallowing join elimination |
QKSFM_TRANSFORMATION_6688200 |
262 |
6694548 |
1 |
10.2.0.4 |
|
Account for chained rows when computing TA by ROWID from bitmap |
QKSFM_CBO_6694548 |
263 |
6699059 |
1 |
11.2.0.1 |
|
enable cardinality feedback-based cursor sharing |
QKSFM_CURSOR_SHARING_6699059 |
264 |
6708183 |
0 |
|
|
allow dynamic sampling on table functions |
QKSFM_DYNAMIC_SAMPLING_6708183 |
265 |
6714199 |
1 |
10.2.0.5 |
|
Enable pushup through both dimensions for PWJ |
QKSFM_PARTITION_6714199 |
266 |
6720701 |
1 |
8.0.0 |
|
Apply the pre 10.1 1000 expressions limit for multi-table insert |
QKSFM_DML_6720701 |
267 |
6748058 |
1 |
11.1.0.7 |
|
allow parallelization of DFO consuming correlated variables |
QKSFM_SQL_CODE_GENERATOR_6748058 |
268 |
6751206 |
1 |
10.2.0.5 |
|
Change distribution method between Load and Query DFO's |
QKSFM_DML_6751206 |
269 |
6754080 |
1 |
11.2.0.2 |
|
enable expression replacement thru views |
QKSFM_ACCESS_PATH_6754080 |
270 |
6765823 |
1 |
11.2.0.1 |
|
intersect predicates across predicate subtrees |
QKSFM_CBO_6765823 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
271 |
6766962 |
1 |
11.1.0.7 |
|
sample size in DS is at most equal to the partition sample size |
QKSFM_DYNAMIC_SAMPLING_6766962 |
272 |
6768660 |
1 |
11.2.0.1 |
|
generate transitive predicates across predicate subtrees |
QKSFM_CBO_6768660 |
273 |
6769711 |
1 |
11.2.0.1 |
|
View merge if cursor is argument to table function |
QKSFM_SVM_6769711 |
274 |
6771838 |
1 |
10.2.0.5 |
|
allow JPPD with empty single table branch |
QKSFM_JPPD_6771838 |
275 |
6773613 |
1 |
10.2.0.5 |
|
BETWEEN simplification for functions of constants |
QKSFM_CBO_6773613 |
276 |
6774209 |
1 |
11.2.0.1 |
|
interleaved CVM is chosen even if interleaved JPPD is cheaper |
QKSFM_TRANSFORMATION_6774209 |
277 |
6776808 |
1 |
11.1.0.7 |
|
allow view merging for inline views defined in WITH clause |
QKSFM_SVM_6776808 |
278 |
6778642 |
1 |
10.2.0.5 |
|
Restrict transitive predicates for remote query blocks |
QKSFM_CBO_6778642 |
279 |
6782437 |
1 |
10.2.0.5 |
|
consider predicate pushing underneath view with CONNECT BY |
QKSFM_FILTER_PUSH_PRED_6782437 |
280 |
6782665 |
1 |
11.2.0.1 |
|
eliminate common subexpression for simple disjunct predicates |
QKSFM_CSE_6782665 |
281 |
6808773 |
0 |
|
|
gracefully handle skew on nulls for outer-join |
QKSFM_EXECUTION_6808773 |
282 |
6818410 |
1 |
11.2.0.1 |
|
eliminate redundant inlist predicates |
QKSFM_CBO_6818410 |
283 |
6820988 |
1 |
10.2.0.5 |
|
pick the dimension with the highest # of granules for PPWJ |
QKSFM_PARTITION_6820988 |
284 |
6827696 |
1 |
11.2.0.1 |
|
eliminate duplicate predicates across subtrees |
QKSFM_CBO_6827696 |
285 |
6838105 |
1 |
10.2.0.5 |
|
change qksopCheckNoPrior to check for subqueries and not for fro |
QKSFM_COMPILATION_6838105 |
286 |
6845871 |
1 |
10.2.0.5 |
|
FKR: apply subquery filtering factor on all-rows cardinality |
QKSFM_FIRST_ROWS_6845871 |
287 |
6897034 |
1 |
10.2.0.5 |
|
index cardinality estimates not taking into account NULL rows |
QKSFM_ACCESS_PATH_6897034 |
288 |
6904146 |
1 |
10.2.0.5 |
|
eliminate check for number of elements in a row vector |
QKSFM_PQ_6904146 |
289 |
6913094 |
1 |
11.2.0.1 |
|
enable PWJ for non-natural join orders on ref-part table |
QKSFM_PARTITION_6913094 |
290 |
6917633 |
1 |
11.1.0.7 |
|
merge selectivity range for single predicate |
QKSFM_CURSOR_SHARING_6917633 |
291 |
6941515 |
0 |
|
|
use high watermark brokering for insert into single segment |
QKSFM_DML_6941515 |
292 |
6942476 |
1 |
11.2.0.1 |
|
early filter pushdown in all query blocks |
QKSFM_FILTER_PUSH_PRED_6942476 |
293 |
6951776 |
1 |
11.2.0.1 |
|
Fix inadequate PK/FK marking for tables in from clause |
QKSFM_TRANSFORMATION_6951776 |
294 |
6955210 |
1 |
8.0.0 |
|
Enable exchange partition update global indexes to go parallel |
QKSFM_PARTITION_6955210 |
295 |
6956212 |
1 |
10.2.0.5 |
|
allow dynamic sampling when OR-expansion is used |
QKSFM_DYNAMIC_SAMPLING_6956212 |
296 |
6972291 |
0 |
|
|
Choose column group ndv over histograms of individual cols |
QKSFM_CBO_6972291 |
297 |
6972987 |
1 |
11.2.0.1 |
|
sanity check for # of rows before using it for selectivity estim |
QKSFM_CBO_6972987 |
298 |
6980350 |
1 |
11.2.0.1 |
|
fix fast full scan index only determination |
QKSFM_CBO_6980350 |
299 |
6982954 |
1 |
11.1.0.7 |
|
bloom filter for hash join with broadcast left |
QKSFM_PQ_6982954 |
300 |
6987082 |
0 |
|
|
push join pred with single UV branch not promoting index |
QKSFM_JPPD_6987082 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
301 |
6990305 |
1 |
10.2.0.5 |
|
allow bind peeking during CBQT |
QKSFM_TRANSFORMATION_6990305 |
302 |
6994194 |
1 |
10.2.0.5 |
|
share kccdef while copying standalone predicates |
QKSFM_TRANSFORMATION_6994194 |
303 |
7032684 |
1 |
11.2.0.1 |
|
Allow non-well-formed correlated predicates in unnesting |
QKSFM_TRANSFORMATION_7032684 |
304 |
7043307 |
1 |
11.2.0.1 |
|
remove tbl join predicate for PWJ |
QKSFM_PARTITION_7043307 |
305 |
7116357 |
1 |
10.2.0.5 |
|
allow APPROX_GLOBAL in presence of non-analyzed partitions |
QKSFM_DBMS_STATS_7116357 |
306 |
7127530 |
1 |
11.2.0.1 |
|
window function replaces having subquery |
QKSFM_TRANSFORMATION_7127530 |
307 |
7127980 |
1 |
11.2.0.1 |
|
cost top-level AND'd subqueries inside of expressions |
QKSFM_CBO_7127980 |
308 |
7132036 |
1 |
10.2.0.5 |
|
Correct concatenated index based join selectivity estimation |
QKSFM_CBO_7132036 |
309 |
7132684 |
1 |
10.2.0.5 |
|
Fix costing for non prefixed local index |
QKSFM_CBO_7132684 |
310 |
7135745 |
1 |
10.2.0.5 |
|
allow first K rows optimization for all CTAS and IAS |
QKSFM_FIRST_ROWS_7135745 |
311 |
7138405 |
1 |
10.2.0.5 |
|
push or-chain with at least 1 non-constanct branch into UV |
QKSFM_FILTER_PUSH_PRED_7138405 |
312 |
7147087 |
1 |
10.2.0.5 |
|
check for decrypt-to-encrypt both sides of equality predicate |
QKSFM_CBO_7147087 |
313 |
7148689 |
1 |
10.2.0.5 |
|
Allow fix of bug 2218788 for in-list predicates |
QKSFM_CBO_7148689 |
314 |
7155968 |
1 |
11.1.0.7 |
|
Restrict use of disabled FFS on IOTs |
QKSFM_ACCESS_PATH_7155968 |
315 |
7165898 |
1 |
10.2.0.5 |
|
do not mark primary keys for DML in absence of candidate qb |
QKSFM_PRED_MOVE_AROUND_7165898 |
316 |
7168184 |
1 |
11.2.0.1 |
|
allow pushing of complex predicates to scan |
QKSFM_EXECUTION_7168184 |
317 |
7170213 |
1 |
8.0.0 |
|
do not raise ORA-12842 if the user so desires |
QKSFM_PQ_7170213 |
318 |
7176746 |
1 |
10.2.0.5 |
|
No AJ/SJ index sel adj, if leading index col has non equality pr |
QKSFM_CBO_7176746 |
319 |
7199035 |
1 |
11.2.0.1 |
|
bloom filter with broadcast left for partial parallel plan |
QKSFM_PQ_7199035 |
320 |
7208131 |
1 |
10.2.0.5 |
|
plan change with INDEX_JOIN hint |
QKSFM_ACCESS_PATH_7208131 |
321 |
7215982 |
1 |
11.2.0.2 |
|
unnest subquery embedded inside an expression |
QKSFM_UNNEST_7215982 |
322 |
7236148 |
1 |
10.2.0.5 |
|
FKR: prorate chained row count |
QKSFM_FIRST_ROWS_7236148 |
323 |
7237571 |
1 |
10.2.0.5 |
|
NVL Optimization |
QKSFM_CBO_7237571 |
324 |
7241819 |
1 |
10.2.0.5 |
|
cannot use a global index if part ext tab name and sampling |
QKSFM_ACCESS_PATH_7241819 |
325 |
7249095 |
1 |
10.2.0.5 |
|
Include cost of subqueries in SET of UPDATE in total cost |
QKSFM_CBO_7249095 |
326 |
7259468 |
1 |
10.2.0.5 |
|
No distinct elimination for connect by subquery |
QKSFM_UNNEST_7259468 |
327 |
7263214 |
1 |
10.2.0.5 |
|
top view of insert as select is not positionable as well |
QKSFM_SQL_CODE_GENERATOR_7263214 |
328 |
7272039 |
1 |
10.2.0.5 |
|
use index cost adj when comparing skip scan with full table scan |
QKSFM_ACCESS_PATH_7272039 |
329 |
7277732 |
1 |
11.2.0.2 |
|
allow skip scan costing for NL with non-join predicate |
QKSFM_CBO_7277732 |
330 |
7281191 |
1 |
10.2.0.5 |
|
Try to generate IS NOT NULL from LIKE with leading wildcard |
QKSFM_TRANSFORMATION_7281191 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
331 |
7284269 |
1 |
11.2.0.2 |
|
extended cursor sharing for like predicates |
QKSFM_CURSOR_SHARING_7284269 |
332 |
7289023 |
1 |
10.2.0.5 |
|
ignore bitmap_merge_area_size when running under auto PGA |
QKSFM_CBO_7289023 |
333 |
7295298 |
1 |
10.2.0.5 |
|
Rank subquery filter based on cost |
QKSFM_CBO_7295298 |
334 |
7298570 |
1 |
10.2.0.5 |
|
skip STRTCIOUT while checking NOT NULL |
QKSFM_UNNEST_7298570 |
335 |
7298626 |
1 |
11.2.0.1 |
|
Allow multi-column null-aware antijoin |
QKSFM_TRANSFORMATION_7298626 |
336 |
7306637 |
1 |
11.2.0.1 |
|
inject SORT BUFFER under FOR UPDATE |
QKSFM_SQL_CODE_GENERATOR_7306637 |
337 |
7314499 |
1 |
11.2.0.1 |
|
compress TRUE/FALSE predicate subtrees |
QKSFM_CBO_7314499 |
338 |
7324224 |
1 |
11.2.0.1 |
|
remove predicates that are redundant because of subtrees |
QKSFM_CBO_7324224 |
339 |
7325597 |
1 |
10.2.0.5 |
|
amend condition for 6120483 to require inlist index key |
QKSFM_ACCESS_PATH_7325597 |
340 |
7341616 |
1 |
10.2.0.5 |
|
use equal-to-constant predicates with functional index keys |
QKSFM_INDEX_7341616 |
341 |
7345484 |
1 |
10.2.0.3 |
|
merge outerjoined lateral view with filter on left table |
QKSFM_TRANSFORMATION_7345484 |
342 |
7356191 |
1 |
10.2.0.5 |
|
adjust antijoin selectivity to favor over-estimate |
QKSFM_CBO_7356191 |
343 |
7375077 |
1 |
10.2.0.5 |
|
use the number of elements in a collection as table cardinality |
QKSFM_CARDINALITY_7375077 |
344 |
7375179 |
1 |
11.2.0.1 |
|
enable subquery pruning on ref-part table |
QKSFM_PARTITION_7375179 |
345 |
7385140 |
1 |
11.2.0.1 |
|
early window function removal with CBQT |
QKSFM_TRANSFORMATION_7385140 |
346 |
7388652 |
1 |
11.2.0.1 |
|
window function replaces uncorrelated subquery with view |
QKSFM_TRANSFORMATION_7388652 |
347 |
7414637 |
1 |
11.2.0.1 |
|
sanity check for selectivity estimated for single predicate |
QKSFM_CBO_7414637 |
348 |
7426911 |
1 |
11.2.0.1 |
|
no duplicate select list items in kkqtutlGenInlineView |
QKSFM_TRANSFORMATION_7426911 |
349 |
7430474 |
1 |
10.2.0.5 |
|
try all pssible sort eliminating indexes |
QKSFM_ACCESS_PATH_7430474 |
350 |
7449971 |
1 |
11.2.0.1 |
|
apply virtual column replacement after transformation |
QKSFM_TRANSFORMATION_7449971 |
351 |
7452823 |
0 |
|
|
cap effective parallelism by NDV |
QKSFM_PARTITION_7452823 |
352 |
7452863 |
1 |
11.2.0.1 |
|
adjust DS level for large parallel tables based on the size |
QKSFM_DYNAMIC_SAMPLING_7452863 |
353 |
7499258 |
1 |
11.2.0.1 |
|
enable copy of lateral view for CBQT |
QKSFM_TRANSFORMATION_7499258 |
354 |
7512227 |
1 |
8.0.0 |
|
identity operators for bind sharing with outer joins |
QKSFM_COMPILATION_7512227 |
355 |
7519687 |
1 |
10.2.0.5 |
|
enable complex view merging with correlation to a merged view |
QKSFM_TRANSFORMATION_7519687 |
356 |
7521266 |
1 |
10.2.0.5 |
|
Eliminate unnecessary sort above iterator for single partition |
QKSFM_PARTITION_7521266 |
357 |
7524366 |
1 |
8.0.0 |
|
enable JPPD for insert statements |
QKSFM_JPPD_7524366 |
358 |
7528216 |
1 |
10.2.0.5 |
|
disallow automatic first k-rows for subqueries with group-by |
QKSFM_FIRST_ROWS_7528216 |
359 |
7534027 |
1 |
11.2.0.1 |
|
Remove redundant items from group-by list |
QKSFM_CVM_7534027 |
360 |
7534257 |
1 |
8.0.0 |
|
add columns to sort row vector for parallel insert |
QKSFM_PQ_7534257 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
361 |
7539815 |
1 |
8.0.0 |
|
ensure suffix elements match when testing for partition wise joi |
QKSFM_COMPILATION_7539815 |
362 |
7555510 |
1 |
10.2.0.5 |
|
transitive predicates is not generated for UNION ALL views' join |
QKSFM_TRANSFORMATION_7555510 |
363 |
7556098 |
1 |
10.2.0.5 |
|
do not pull up UOP if DOI defined on it |
QKSFM_PULL_PRED_7556098 |
364 |
7558911 |
1 |
11.2.0.1 |
|
Enable parallel PWJ with pushup of any level after absolute leve |
QKSFM_PARTITION_7558911 |
365 |
7573526 |
1 |
8.0.0 |
|
set qbctjp to null |
QKSFM_TRANSFORMATION_7573526 |
366 |
7576476 |
1 |
10.2.0.5 |
|
remove redundant IS [NOT] NULL predicates |
QKSFM_CBO_7576476 |
367 |
7576516 |
1 |
10.2.0.5 |
|
make only the topmost window node positionable |
QKSFM_SQL_CODE_GENERATOR_7576516 |
368 |
7585456 |
1 |
10.2.0.5 |
|
return correct subpartition count for composite partitioned tabl |
QKSFM_PARTITION_7585456 |
369 |
7592673 |
1 |
10.2.0.5 |
|
do not use dyn sampling index selectivity if not all keys sample |
QKSFM_DYNAMIC_SAMPLING_7592673 |
370 |
7597059 |
1 |
10.2.0.5 |
|
session crash due to jo->kkojopos is not reset at join abortion |
QKSFM_JOIN_ORDER_7597059 |
371 |
7597159 |
1 |
11.2.0.1 |
|
Prune unreferenced view columns from select list |
QKSFM_TRANSFORMATION_7597159 |
372 |
7613118 |
1 |
11.2.0.1 |
|
bloom filter costing takes account of join input swap |
QKSFM_PQ_7613118 |
373 |
7628358 |
1 |
8.0.0 |
|
Wrong results from join elim with join pred under OR |
QKSFM_TABLE_ELIM_7628358 |
374 |
7640597 |
1 |
8.0.0 |
|
defer cursor invalidation during the truncate operation |
QKSFM_CURSOR_SHARING_7640597 |
375 |
7641601 |
1 |
11.2.0.2 |
|
treat a single value column as having a frequency histogram |
QKSFM_CARDINALITY_7641601 |
376 |
7650462 |
1 |
11.2.0.1 |
|
Invoke CBQT star transformation before JPPD |
QKSFM_STAR_TRANS_7650462 |
377 |
7657126 |
1 |
10.2.0.5 |
|
amend index selectivity calculation for inlists |
QKSFM_ACCESS_PATH_7657126 |
378 |
7658097 |
0 |
|
|
Disable group-by placement under certain conditions |
QKSFM_TRANSFORMATION_7658097 |
379 |
7670533 |
1 |
8.0.0 |
|
Do not use an existing outline when re-building an outline |
QKSFM_OUTLINE_7670533 |
380 |
7675944 |
1 |
10.2.0.5 |
|
Extend subquery partition pruning to consider constant predicate |
QKSFM_PARTITION_7675944 |
381 |
7676897 |
0 |
|
|
Disable CVM for distinct view when CBQT is invalid |
QKSFM_CVM_7676897 |
382 |
7679161 |
1 |
11.2.0.1 |
|
Additional call to view merging after table elimination |
QKSFM_TABLE_ELIM_7679161 |
383 |
7679164 |
1 |
11.2.0.1 |
|
Table elimination for primary key self joins |
QKSFM_TABLE_ELIM_7679164 |
384 |
7679490 |
0 |
|
|
peek sysdate when checking index usability |
QKSFM_PARTITION_7679490 |
385 |
7696414 |
1 |
10.2.0.5 |
38074 |
Allow general constant expressions involving binds for LIKE as E |
QKSFM_CARDINALITY_7696414 |
386 |
7708267 |
1 |
10.2.0.5 |
|
don't buffer QC-produced DFO if possible |
QKSFM_PQ_7708267 |
387 |
7711900 |
1 |
11.2.0.2 |
|
copy query block text position fields in copy service |
QKSFM_CBQT_7711900 |
388 |
7718694 |
1 |
11.2.0.1 |
|
[no]parallel statement hint overrides parallel keyword in ddl |
QKSFM_PQ_7718694 |
389 |
7831070 |
1 |
10.2.0.5 |
|
Allow connect by prior predicates to be considered for pruning |
QKSFM_PARTITION_7831070 |
390 |
7834811 |
1 |
10.2.0.5 |
|
allow in-list iterators for hash clusters |
QKSFM_ACCESS_PATH_7834811 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
391 |
8198783 |
0 |
|
|
master HV enqueues on instances participating in the load |
QKSFM_DML_8198783 |
392 |
8202421 |
1 |
11.2.0.1 |
|
Improve selectivity of join preds on NVL - traverse predicate tr |
QKSFM_CARDINALITY_8202421 |
393 |
8213977 |
1 |
10.2.0.5 |
|
limit or-expanded query block cardinality in first_rows(k) |
QKSFM_CBO_8213977 |
394 |
8214022 |
1 |
11.2.0.2 |
|
perform additional CBQT phase for subquery unnesting |
QKSFM_UNNEST_8214022 |
395 |
8226666 |
1 |
8.0.0 |
|
versions query for archiving for flashback archive |
QKSFM_FBA_8226666 |
396 |
8243446 |
1 |
11.2.0.1 |
|
do not create bloom filter for broadcast if not pushable to scan |
QKSFM_PQ_8243446 |
397 |
8247017 |
1 |
10.2.0.5 |
|
do not use 1/NDK as index selectivity with out-of-range keys |
QKSFM_CBO_8247017 |
398 |
8251486 |
1 |
11.1.0.7 |
|
don't buffer sequence if DFO output is already buffered |
QKSFM_PQ_8251486 |
399 |
8255423 |
1 |
8.0.0 |
|
slave sorting and key sampling for parallel create/rebuild index |
QKSFM_PQ_8255423 |
400 |
8274946 |
1 |
11.2.0.3 |
|
simplify range to equality for join predicates |
QKSFM_CBO_8274946 |
401 |
8275023 |
1 |
11.2.0.3 |
|
simplify disjoint range to false |
QKSFM_CBO_8275023 |
402 |
8275054 |
1 |
11.2.0.3 |
|
simplify range to inequality |
QKSFM_CBO_8275054 |
403 |
8284930 |
1 |
11.2.0.1 |
|
return correct partition range during subquery pruning |
QKSFM_PARTITION_8284930 |
404 |
8287870 |
1 |
8.0.0 |
|
disable the permutation of join key by qkkPoesPUJoin() in kkfd.c |
QKSFM_PQ_8287870 |
405 |
8289316 |
1 |
10.2.0.5 |
|
allow order-by elimination for DML statements |
QKSFM_OBYE_8289316 |
406 |
8318020 |
1 |
8.0.0 |
|
Enable new sample pct computation for histograms |
QKSFM_DBMS_STATS_8318020 |
407 |
8323407 |
1 |
10.2.0.5 |
|
use single row to cost index filter |
QKSFM_ACCESS_PATH_8323407 |
408 |
8328363 |
1 |
11.2.0.1 |
|
Put virtual column predicates on index filter |
QKSFM_CBO_8328363 |
409 |
8335178 |
1 |
11.2.0.1 |
|
correct Anti Join overlap selectivity |
QKSFM_CBO_8335178 |
410 |
8348392 |
1 |
11.2.0.1 |
|
do not use statistics from unusable or invisible indexes |
QKSFM_INDEX_STATS_8348392 |
411 |
8348585 |
1 |
8.0.0 |
|
share LOAD buffer slots across partitions |
QKSFM_DML_8348585 |
412 |
8349119 |
1 |
11.2.0.3 |
|
parallel versions query for archiving for flashback archive |
QKSFM_FBA_8349119 |
413 |
8352378 |
1 |
11.2.0.2 |
|
Allow virtual columns in OR expansion index access |
QKSFM_CBO_8352378 |
414 |
8355120 |
1 |
11.2.0.1 |
|
correct selectivity of aggr [not] exists subquery |
QKSFM_CBO_8355120 |
415 |
8356253 |
1 |
11.2.0.1 |
|
Cardinality feedback with binds, group by, indexes |
QKSFM_CURSOR_SHARING_8356253 |
416 |
8371884 |
1 |
10.2.0.5 |
|
star transformation fact candidate should use two or more indexe |
QKSFM_STAR_TRANS_8371884 |
417 |
8373261 |
1 |
11.2.0.1 |
|
Lift restriction on lateral view merge in presence of cursor exp |
QKSFM_TRANSFORMATION_8373261 |
418 |
8408665 |
1 |
11.2.0.1 |
|
allow join selectivity cdn sanity check when unanlyzed tables |
QKSFM_CARDINALITY_8408665 |
419 |
8442891 |
1 |
11.2.0.1 |
|
fix query block registry for inline views |
QKSFM_TRANSFORMATION_8442891 |
420 |
8447850 |
1 |
11.2.0.1 |
38044 |
Peek binds in the having clause |
QKSFM_CBO_8447850 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
421 |
8467123 |
1 |
10.2.0.5 |
|
amend costing for index min/max access with filters |
QKSFM_CBO_8467123 |
422 |
8491399 |
1 |
11.2.0.1 |
|
improve selectivity estimation for ACS |
QKSFM_CURSOR_SHARING_8491399 |
423 |
8500130 |
1 |
11.2.0.2 |
|
enable rownum optimization without partition pushup |
QKSFM_EXECUTION_8500130 |
424 |
8508056 |
1 |
11.2.0.1 |
|
Unnecessary calls to qksvcReplaceIndexExpr() |
QKSFM_CBO_8508056 |
425 |
8514561 |
1 |
8.0.0 |
|
enable optkdustoopn operator for compare columns |
QKSFM_EXECUTION_8514561 |
426 |
8515269 |
1 |
11.2.0.1 |
|
Virtual column replacement for connect by and ansi join queries |
QKSFM_CBO_8515269 |
427 |
8519457 |
1 |
10.2.0.5 |
|
amend outer join cardinality calculation for logical antijoin |
QKSFM_CBO_8519457 |
428 |
8528517 |
1 |
11.2.0.2 |
|
early query edit checks use weak typecheck expression comparison |
QKSFM_TRANSFORMATION_8528517 |
429 |
8531463 |
1 |
11.2.0.2 |
|
cost cutoff for bitmap OR chains based on best table access cost |
QKSFM_ACCESS_PATH_8531463 |
430 |
8531490 |
1 |
11.2.0.1 |
|
do not restore cardinality if semi join elimination is selected |
QKSFM_CBO_8531490 |
431 |
8532236 |
1 |
8.0.0 |
|
handle virtual columns in query edit routines |
QKSFM_CBO_8532236 |
432 |
8551880 |
1 |
11.2.0.2 |
|
Rewrite decode predicate to join |
QKSFM_CBO_8551880 |
433 |
8557992 |
1 |
11.1.0.7 |
|
Enhance functional index checks when considering OR-expansion |
QKSFM_ACCESS_PATH_8557992 |
434 |
8560951 |
0 |
|
|
allow SVM with multiply-referenced subquery |
QKSFM_TRANSFORMATION_8560951 |
435 |
8571403 |
1 |
8.0.0 |
|
drain table queues after slave reaches EOF |
QKSFM_PQ_8571403 |
436 |
8578587 |
1 |
10.2.0.5 |
|
push filters through union all branches |
QKSFM_FILTER_PUSH_PRED_8578587 |
437 |
8580883 |
1 |
10.2.0.5 |
|
Relax restriction on veiw merging for DML statements |
QKSFM_TRANSFORMATION_8580883 |
438 |
8589278 |
0 |
|
|
disable hwm brokering for insert if distribution is PKEY |
QKSFM_DML_8589278 |
439 |
8590021 |
1 |
11.2.0.2 |
|
using col stats for pred NVL() const selectivity estimation |
QKSFM_CBO_8590021 |
440 |
8595392 |
1 |
11.2.0.2 |
|
reject join predicate pushdown if parallel access path selected |
QKSFM_CBO_8595392 |
441 |
8602185 |
1 |
10.2.0.5 |
|
Allow unique index access for multicolumn inlist |
QKSFM_ACCESS_PATH_8602185 |
442 |
8602840 |
1 |
11.2.0.2 |
|
kkeRangeJoinSel should avoid using collapsed min/max column stat |
QKSFM_CBO_8602840 |
443 |
8609714 |
1 |
8.0.0 |
|
adjust dop for in memory pq |
QKSFM_PQ_8609714 |
444 |
8619631 |
0 |
|
|
Allow hash aggregation for insert select except for plsql calls |
QKSFM_COMPILATION_8619631 |
445 |
8628970 |
1 |
11.2.0.2 |
|
group predicates like col op const of 1 NDV col |
QKSFM_CBO_8628970 |
446 |
8629716 |
1 |
11.2.0.2 |
|
enable early replacement for virtual columns |
QKSFM_CBO_8629716 |
447 |
8644935 |
1 |
11.2.0.2 |
|
new parallelization of concat |
QKSFM_PQ_8644935 |
448 |
8672915 |
1 |
10.2.0.5 |
|
relax restriction for distinct union-all branches |
QKSFM_JPPD_8672915 |
449 |
8675087 |
1 |
8.0.0 |
|
correctly prune duplicate operands in order by sort row vector |
QKSFM_COMPILATION_8675087 |
450 |
8683604 |
1 |
11.2.0.3 |
|
allow NLJ if there is no sub-query pruning (absolute dimension) |
QKSFM_PARTITION_8683604 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
451 |
8685327 |
1 |
11.2.0.2 |
|
Heuristic to enable full index scan used if table & index analyz |
QKSFM_ACCESS_PATH_8685327 |
452 |
8692170 |
1 |
11.2.0.2 |
|
do not apply JF if it prevents JPPD |
QKSFM_TRANSFORMATION_8692170 |
453 |
8693158 |
1 |
11.2.0.2 |
|
consider pushing if only shared predicates to push |
QKSFM_JPPD_8693158 |
454 |
8706652 |
1 |
11.2.0.2 |
|
fix for 7449971 not complete |
QKSFM_CBO_8706652 |
455 |
8725296 |
1 |
11.2.0.2 |
|
try non-driver predicate only if advanced check requested |
QKSFM_OR_EXPAND_8725296 |
456 |
8760135 |
1 |
11.2.0.2 |
|
allow compile-time peeking of CURRENT_DATE / CURRENT_TIMESTAMP |
QKSFM_CBO_8760135 |
457 |
8763472 |
1 |
11.2.0.2 |
|
enable parallel nested loop PWJ for ref-part tables |
QKSFM_PARTITION_8763472 |
458 |
8767442 |
1 |
11.2.0.2 |
|
compute NDV for all columns in a multi-column join key using DS |
QKSFM_DYNAMIC_SAMPLING_8767442 |
459 |
8773324 |
1 |
11.2.0.2 |
|
better recognition of index only plans with virtual columns |
QKSFM_CBO_8773324 |
460 |
8792846 |
1 |
11.2.0.2 |
|
use _optimizer_star_trans_min_ratio even if ST not hinted |
QKSFM_STAR_TRANS_8792846 |
461 |
8800514 |
20 |
11.2.0.2 |
|
threshold of table count to disable extended JPPD |
QKSFM_JPPD_8800514 |
462 |
8802198 |
1 |
8.0.0 |
|
single-column NAAJ, distribute right side by value |
QKSFM_COMPILATION_8802198 |
463 |
8812372 |
1 |
8.0.0 |
|
improved fake statistics for Index Advisor |
QKSFM_ACCESS_ADVISOR_8812372 |
464 |
8813674 |
1 |
11.2.0.2 |
|
relax restriction for non-nullness check |
QKSFM_TRANSFORMATION_8813674 |
465 |
8833381 |
1 |
8.0.0 |
|
push HV enq init / HWM operations to slave processes |
QKSFM_DML_8833381 |
466 |
8836806 |
1 |
11.2.0.2 |
|
push rownum predicate into sortable domain index |
QKSFM_CBO_8836806 |
467 |
8855396 |
1 |
11.2.0.2 |
|
sanity check for skip scan costing |
QKSFM_ACCESS_PATH_8855396 |
468 |
8890233 |
1 |
11.2.0.2 |
|
enable pushing bloom filter through NLJ |
QKSFM_PQ_8890233 |
469 |
8893626 |
1 |
11.2.0.2 |
|
apply index filter selectivity during skip scan costing |
QKSFM_ACCESS_PATH_8893626 |
470 |
8896955 |
1 |
11.2.0.2 |
|
interleave TE with ST and JF |
QKSFM_TRANSFORMATION_8896955 |
471 |
8900973 |
1 |
11.2.0.2 |
|
relax restriction on inequality join for group-by placement (GBP |
QKSFM_TRANSFORMATION_8900973 |
472 |
8901237 |
1 |
11.2.0.2 |
|
correct search of state-space for group-by placement (GBP) |
QKSFM_TRANSFORMATION_8901237 |
473 |
8917507 |
7 |
8.0.0 |
|
Incremental for tab subpart and local indexes |
QKSFM_DBMS_STATS_8917507 |
474 |
8919133 |
1 |
11.2.0.2 |
|
correct nested OR costing bug |
QKSFM_CBO_8919133 |
475 |
8927050 |
1 |
8.0.0 |
|
allow tables with lob columns to support online add columns |
QKSFM_TRANSFORMATION_8927050 |
476 |
8937971 |
0 |
|
|
write default storage attribute values to deferred_stg$ |
QKSFM_ALL_8937971 |
477 |
8949971 |
1 |
11.2.0.2 |
|
make stats for leaf level data appear very large in COTs |
QKSFM_STATS_8949971 |
478 |
8951812 |
1 |
8.0.0 |
|
check indrebuild$ for dataobj# when applying undo if OIC mismatc |
QKSFM_DML_8951812 |
479 |
8961143 |
1 |
11.2.0.3 |
|
enable better partition pushup in local bitamp join index creati |
QKSFM_PARTITION_8961143 |
480 |
8971829 |
1 |
11.2.0.2 |
|
set KKEGIXSL for unpartitioned global index |
QKSFM_ACCESS_PATH_8971829 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
481 |
8973745 |
1 |
11.2.0.2 |
|
auto-capture only if literal replaced SQL parses recursively |
QKSFM_SQL_PLAN_MANAGEMENT_8973745 |
482 |
8986163 |
1 |
11.2.0.2 |
|
align partition-wise gby DOP requirements with partition-wise jo |
QKSFM_PQ_8986163 |
483 |
8999317 |
1 |
11.2.0.2 |
|
correct cost comparison for the additional phase for JPPD |
QKSFM_UNNEST_8999317 |
484 |
9002661 |
1 |
11.2.0.3 |
|
Process mqb |
QKSFM_FILTER_PUSH_PRED_9002661 |
485 |
9004800 |
1 |
10.2.0.5 |
|
determine out of range values for simple binds |
QKSFM_CBO_9004800 |
486 |
9007859 |
1 |
11.2.0.2 |
|
Context index to be picked on XMLType Columns |
QKSFM_CBO_9007859 |
487 |
9011016 |
1 |
11.2.0.2 |
|
use 1/NDV+1/NROWS for col1 LIKE col2 selectivities (index driver |
QKSFM_ACCESS_PATH_9011016 |
488 |
9024933 |
1 |
11.2.0.2 |
|
Do not allow Old JPPD for OJ view with window function |
QKSFM_JPPD_9024933 |
489 |
9033718 |
1 |
11.2.0.2 |
|
remove restriction on bind variables for table expansion |
QKSFM_TABLE_EXPANSION_9033718 |
490 |
9038395 |
1 |
8.0.0 |
|
directly write synopses to disk in approximate NDV engine |
QKSFM_DBMS_STATS_9038395 |
491 |
9039715 |
1 |
8.0.0 |
|
perform round-robin granule allocation in terms of instances |
QKSFM_PQ_9039715 |
492 |
9041934 |
1 |
11.2.0.2 |
|
use selected measures for AW LOOP OPTIMIZED looping strategy |
QKSFM_EXECUTION_9041934 |
493 |
9047975 |
1 |
11.2.0.2 |
|
improve selectivity for truncated character strings |
QKSFM_CBO_9047975 |
494 |
9052506 |
1 |
11.2.0.2 |
|
Allow NAAJ for UPDATE and DELETE |
QKSFM_UNNEST_9052506 |
495 |
9053879 |
1 |
11.2.0.2 |
|
search all query blocks for replacement candidates |
QKSFM_CBO_9053879 |
496 |
9065494 |
1 |
8.0.0 |
|
enable Exadata projection optimization |
QKSFM_SQL_CODE_GENERATOR_9065494 |
497 |
9069046 |
1 |
11.2.0.2 |
|
amend histogram column tracking for multicolumn stats |
QKSFM_CBO_9069046 |
498 |
9081848 |
1 |
11.2.0.2 |
|
don't use fake index stats as extended stats |
QKSFM_CBO_9081848 |
499 |
9088510 |
1 |
11.2.0.2 |
|
compress predicate tree before cost-based query transformation |
QKSFM_TRANSFORMATION_9088510 |
500 |
9092442 |
1 |
11.2.0.2 |
|
equi-partition load |
QKSFM_DML_9092442 |
501 |
9102474 |
1 |
11.2.0.2 |
|
use IO calibrate statistics to estimate time from cost |
QKSFM_CBO_9102474 |
502 |
9103775 |
1 |
8.0.0 |
|
not to miss any partition when merging subpartition stats |
QKSFM_DBMS_STATS_9103775 |
503 |
9106224 |
1 |
11.2.0.2 |
|
allow range distribution in create of global partitioned index |
QKSFM_PQ_9106224 |
504 |
9111170 |
1 |
8.0.0 |
|
allow subquery to appear on left side when generating inline vie |
QKSFM_TRANSFORMATION_9111170 |
505 |
9116214 |
1 |
11.2.0.2 |
|
index filter ordering |
QKSFM_ACCESS_PATH_9116214 |
506 |
9125151 |
1 |
11.2.0.2 |
|
produce more accurate stats for olap when stats has not been run |
QKSFM_STATS_9125151 |
507 |
9143856 |
1 |
11.2.0.2 |
|
uncorrelated OR-ed unary predicates are OK for unnesting |
QKSFM_TRANSFORMATION_9143856 |
508 |
9148171 |
1 |
11.2.0.2 |
|
allow distinct elim & distinct aggr transform for non-select stm |
QKSFM_TRANSFORMATION_9148171 |
509 |
9153459 |
1 |
11.2.0.2 |
|
allow loading of rely constraints for all statement types |
QKSFM_TABLE_ELIM_9153459 |
510 |
9171113 |
1 |
11.2.0.2 |
|
consider parallel cost for partition bitmap table access by rowi |
QKSFM_CBO_9171113 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
511 |
9185228 |
1 |
11.2.0.2 |
|
move correlated filters from subquery to outer query |
QKSFM_UNNEST_9185228 |
512 |
9195582 |
1 |
11.2.0.2 |
|
leaf blocks as upper limit for skip scan blocks |
QKSFM_ACCESS_PATH_9195582 |
513 |
9196440 |
0 |
|
|
correct chunks computation |
QKSFM_STATS_9196440 |
514 |
9203723 |
1 |
11.2.0.2 |
|
allow bloom pruning and bloom filtering on the same join |
QKSFM_SQL_CODE_GENERATOR_9203723 |
515 |
9206747 |
1 |
11.2.0.2 |
|
share metadata for virtual columns when making copy |
QKSFM_CBO_9206747 |
516 |
9218587 |
1 |
11.2.0.2 |
|
Don't use column density for selectivity with 1-bucket histogram |
QKSFM_CARDINALITY_9218587 |
517 |
9227576 |
1 |
11.2.0.3 |
|
allow skip scan costing for semi/anti-join |
QKSFM_CBO_9227576 |
518 |
9239337 |
1 |
11.2.0.2 |
|
eliminate unreferenced subqueries after view merging |
QKSFM_CBO_9239337 |
519 |
9240455 |
1 |
8.0.0 |
|
do not reduce the IO slot size |
QKSFM_DML_9240455 |
520 |
9243499 |
1 |
11.2.0.2 |
|
relax conditions for logical antijoin |
QKSFM_CBO_9243499 |
521 |
9245114 |
1 |
11.2.0.2 |
|
eliminate redundant join predicates in join elimination |
QKSFM_TABLE_ELIM_9245114 |
522 |
9263333 |
1 |
11.2.0.2 |
|
generate transitive predicates for virtual column expressions |
QKSFM_CBO_9263333 |
523 |
9265681 |
1 |
11.2.0.2 |
|
sanity check for derived ndv/cdn for inner join on range |
QKSFM_CARDINALITY_9265681 |
524 |
9270951 |
1 |
8.0.0 |
|
disable the permutation of join key by qkkPoesPPUJoin() |
QKSFM_PQ_9270951 |
525 |
9272549 |
1 |
11.2.0.2 |
|
do not sample columns which have statistics |
QKSFM_DYNAMIC_SAMPLING_9272549 |
526 |
9274675 |
1 |
8.0.0 |
|
buffer consumer DFO with a parallel table function |
QKSFM_PQ_9274675 |
527 |
9287401 |
1 |
11.2.0.2 |
|
full outer join to outer join conversion |
QKSFM_TRANSFORMATION_9287401 |
528 |
9298010 |
1 |
11.2.0.2 |
|
enable pruning for partitioned IOT rowid predicates |
QKSFM_PARTITION_9298010 |
529 |
9300228 |
1 |
8.0.0 |
|
enhanced index unusable checks |
QKSFM_CBO_9300228 |
530 |
9301862 |
0 |
|
|
ORACLE_LOADER: enable DIRECTIO option for data file reads |
QKSFM_EXTTAB_9301862 |
531 |
9303766 |
1 |
11.2.0.2 |
|
use 1/NDV+1/NROWS for col1 LIKE col2 selectivities (table access |
QKSFM_ACCESS_PATH_9303766 |
532 |
9309281 |
1 |
11.2.0.2 |
|
outer join JPPD allowed for function-based index access path |
QKSFM_JPPD_9309281 |
533 |
9340120 |
1 |
11.2.0.2 |
|
derive stats for sys generated UA view selectivity estimation |
QKSFM_CBO_9340120 |
534 |
9342979 |
1 |
11.2.0.2 |
|
disable cardinality feedback for old JPPD |
QKSFM_CURSOR_SHARING_9342979 |
535 |
9344055 |
1 |
11.2.0.2 |
|
Control the memory used during query optimization |
QKSFM_CBO_9344055 |
536 |
9344709 |
1 |
11.2.0.2 |
|
disable parallel execution for a qb with a constant false pred |
QKSFM_PQ_9344709 |
537 |
9355794 |
1 |
11.2.0.2 |
|
clear sort merge joins paths noted in apafjo |
QKSFM_CBO_9355794 |
538 |
9356656 |
1 |
8.0.0 |
|
free parallel slaves upon close by non-restartable row sources |
QKSFM_PQ_9356656 |
539 |
9380298 |
0 |
|
|
JPPD for cartesian joins under fix control |
QKSFM_JPPD_9380298 |
540 |
9381638 |
1 |
11.2.0.2 |
|
Treat CP differently from NLJ for parallel optimizations |
QKSFM_PQ_9381638 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
541 |
9383967 |
1 |
11.2.0.2 |
|
Allow unique (ie. select distinct) pushdown |
QKSFM_COMPILATION_9383967 |
542 |
9384170 |
1 |
8.0.0 |
|
check for overflow before squaring large values |
QKSFM_CBO_9384170 |
543 |
9385634 |
1 |
11.2.0.2 |
|
always return error for null end point expression |
QKSFM_EXECUTION_9385634 |
544 |
9407929 |
1 |
11.2.0.1 |
|
estimate expansion cost for entire or-chain |
QKSFM_OR_EXPAND_9407929 |
545 |
9433490 |
1 |
11.2.0.2 |
|
enable VC replacement for nest operator |
QKSFM_CBO_9433490 |
546 |
9437283 |
1 |
11.2.0.2 |
|
Do not consider NLJ from JPPD when checking for FCP |
QKSFM_CBO_9437283 |
547 |
9443476 |
1 |
11.2.0.2 |
|
set OPNF2NOSEL bit for auto generated virtual column predicates |
QKSFM_CBO_9443476 |
548 |
9456688 |
1 |
11.2.0.2 |
|
account for to_number/to_char cost after temp conversion |
QKSFM_ACCESS_PATH_9456688 |
549 |
9456746 |
0 |
|
|
do not account for index filter cost if table is empty |
QKSFM_ACCESS_PATH_9456746 |
550 |
9465425 |
1 |
11.2.0.2 |
|
correct hint for index join from cardinality feedback |
QKSFM_CURSOR_SHARING_9465425 |
551 |
9474259 |
1 |
11.2.0.2 |
|
use cdn sanity check when unique colgroup on both sides of join |
QKSFM_CBO_9474259 |
552 |
9476520 |
1 |
8.0.0 |
|
error logging specified with instead of trigger |
QKSFM_DML_9476520 |
553 |
9477688 |
1 |
11.2.0.2 |
|
edit check the view QB if it has a group-by |
QKSFM_CVM_9477688 |
554 |
9495669 |
0 |
|
|
do not use histograms in join cardinality calculation |
QKSFM_CARDINALITY_9495669 |
555 |
9508254 |
1 |
8.0.0 |
|
Improve memory usage for versioned objects by freeing old versio |
QKSFM_PARTITION_9508254 |
556 |
9554026 |
0 |
|
|
store index filter selectivity/cost |
QKSFM_ACCESS_PATH_9554026 |
557 |
9569678 |
1 |
11.2.0.3 |
|
skip identity operator when generating NULL IS NOT NULL |
QKSFM_CBO_9569678 |
558 |
9577300 |
1 |
11.2.0.2 |
|
Improve range join selectivity for predicates with round |
QKSFM_CBO_9577300 |
559 |
9578670 |
1 |
8.0.0 |
|
Unpin older versioned object handles when creating a new version |
QKSFM_ALL_9578670 |
560 |
9584723 |
1 |
11.2.0.2 |
|
enable functional indexes for index join |
QKSFM_INDEX_JOIN_9584723 |
561 |
9593547 |
0 |
|
|
estimate selectivity for unique scan predicates |
QKSFM_ACCESS_PATH_9593547 |
562 |
9593680 |
1 |
11.2.0.2 |
|
fix typo in cost computation of subquery filters |
QKSFM_CBO_9593680 |
563 |
9630092 |
0 |
|
|
allow peek on 2nd cursor if 1st cursor was a describe cursor |
QKSFM_COMPILATION_9630092 |
564 |
9659125 |
0 |
|
|
cutoff of table count to disable interleaved CVM and JPPD |
QKSFM_UNNEST_9659125 |
565 |
9668086 |
1 |
11.2.0.3 |
|
Amend selectivity calculation for overlapping column ranges |
QKSFM_CBO_9668086 |
566 |
9680430 |
1 |
11.2.0.3 |
38049 |
Use kko_expcmo instead of expcmo in kkqr |
QKSFM_TRANSFORMATION_9680430 |
567 |
9702850 |
1 |
11.2.0.3 |
|
adjust for NULLs only once for NOT inlists |
QKSFM_ACCESS_PATH_9702850 |
568 |
9716877 |
1 |
11.2.0.3 |
|
Use subquery costs in combined NO FILTERING with START WITH clau |
QKSFM_CBO_9716877 |
569 |
9728438 |
1 |
11.2.0.2 |
|
don't go parallel if no operations are expensive enough |
QKSFM_CBO_9728438 |
570 |
9732434 |
1 |
8.0.0 |
|
Don't use cross branch PQ for OR expanded plan |
QKSFM_OR_EXPAND_9732434 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
571 |
9748015 |
1 |
8.0.0 |
|
ignore missing in-memory metadata table in subquery pruning |
QKSFM_PARTITION_9748015 |
572 |
9762592 |
3 |
11.2.0.2 |
|
fold bloom filter when offload to storage |
QKSFM_PQ_9762592 |
573 |
9776736 |
1 |
11.2.0.3 |
|
lift restriction : domain index indexonly mode for merged view |
QKSFM_ACCESS_PATH_9776736 |
574 |
9785632 |
1 |
8.0.0 |
|
disallow slave group reuse in parallel query |
QKSFM_PQ_9785632 |
575 |
9791810 |
1 |
11.2.0.2 |
|
allow distinct aggregate transform with virtual cols |
QKSFM_TRANSFORMATION_9791810 |
576 |
9814067 |
1 |
11.2.0.3 |
|
Sanity check when estimating range inner join |
QKSFM_CARDINALITY_9814067 |
577 |
9829887 |
1 |
11.2.0.3 |
|
restriction on extended subquery partition pruning |
QKSFM_PARTITION_9829887 |
578 |
9832338 |
0 |
|
|
disallow outer join oper (+) in CONNECT BY and START WITH clause |
QKSFM_COMPILATION_9832338 |
579 |
9833381 |
0 |
|
|
rank predicates before costing |
QKSFM_ACCESS_PATH_9833381 |
580 |
9841679 |
1 |
11.2.0.3 |
|
do not set col count for OPNTPLS |
QKSFM_CVM_9841679 |
581 |
9850461 |
1 |
11.2.0.3 |
|
Enable complex view merging if the order by has subquery |
QKSFM_CVM_9850461 |
582 |
9881812 |
1 |
11.2.0.3 |
|
no first k rows in view under aggregate functions |
QKSFM_FIRST_ROWS_9881812 |
583 |
9898066 |
1 |
11.2.0.3 |
|
use dynamic sampling for columns with wrong stats |
QKSFM_CBO_9898066 |
584 |
9912503 |
1 |
11.2.0.2 |
|
Remove having clause subquery at all levels |
QKSFM_TRANSFORMATION_9912503 |
585 |
9913117 |
1 |
11.2.0.3 |
|
do not rename OJ elimination query blocks after view merging |
QKSFM_TRANSFORMATION_9913117 |
586 |
9940732 |
1 |
11.2.0.3 |
|
enhanced checks for ORDER BY DESC removal via join order |
QKSFM_CBO_9940732 |
587 |
9958518 |
1 |
11.2.0.3 |
|
relax type matching for dates in transitive predicate generation |
QKSFM_CBO_9958518 |
588 |
9980661 |
1 |
11.2.0.3 |
|
sanity check when estimating range inner join cardinality |
QKSFM_CARDINALITY_9980661 |
589 |
10004943 |
1 |
11.2.0.3 |
|
enable removal of group by in subquery for create table |
QKSFM_TRANSFORMATION_10004943 |
590 |
10015652 |
1 |
11.2.0.3 |
|
do not use top level K rows if parent is a blocking operation |
QKSFM_FIRST_ROWS_10015652 |
591 |
10026972 |
1 |
8.0.0 |
|
consistently use first or head piece scans for parallel scans |
QKSFM_PQ_10026972 |
592 |
10038373 |
1 |
11.2.0.3 |
|
Fix usage of transitive join predicate list in subquery pruning |
QKSFM_PARTITION_10038373 |
593 |
10041074 |
1 |
11.2.0.3 |
|
clean stats if OJPPD rejected |
QKSFM_JPPD_10041074 |
594 |
10043801 |
1 |
11.2.0.3 |
|
costing of disjunctive subqueries |
QKSFM_CBO_10043801 |
595 |
10080014 |
1 |
11.2.0.3 |
|
allow skip scan costing for PRIOR join in CONNECT BY query |
QKSFM_CBO_10080014 |
596 |
10101489 |
1 |
8.0.0 |
|
send first row as early as possible for exists or not-exists que |
QKSFM_PQ_10101489 |
597 |
10117760 |
1 |
11.2.0.3 |
|
cardinality feedback should account for bloom filters |
QKSFM_CURSOR_SHARING_10117760 |
598 |
10134677 |
1 |
11.2.0.3 |
|
No selectivity for transitive inlist predicate from equijoin |
QKSFM_CBO_10134677 |
599 |
10148457 |
1 |
11.2.0.3 |
|
constant predicate having empty string should be treated unknown |
QKSFM_CBO_10148457 |
600 |
10158107 |
1 |
11.2.0.1 |
|
allow push into single table view, even if table is remote |
QKSFM_JPPD_10158107 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
601 |
10162430 |
1 |
11.2.0.3 |
|
plan hash value ignores tables starting with SYS_TEMP |
QKSFM_CBO_10162430 |
602 |
10182051 |
3 |
|
|
Limit on predicates in bind equiv context (raised to power of 2) |
QKSFM_CURSOR_SHARING_10182051 |
603 |
10192889 |
1 |
11.2.0.3 |
|
consider parallel cost for partitioned local bitmap index access |
QKSFM_CBO_10192889 |
604 |
10197666 |
1 |
8.0.0 |
|
better unusable index checking for reference partition pruning |
QKSFM_PARTITION_10197666 |
605 |
10226906 |
1 |
11.2.0.3 |
|
ignore OBY clumping for grand-total window functions |
QKSFM_SQL_CODE_GENERATOR_10226906 |
606 |
10227392 |
1 |
11.2.0.3 |
|
set gby cardinality 1 based on col=expr only if expr is constant |
QKSFM_CBO_10227392 |
607 |
10230017 |
1 |
11.2.0.3 |
|
use range parallelism for window function count on a constant |
QKSFM_SQL_CODE_GENERATOR_10230017 |
608 |
10232225 |
1 |
11.2.0.3 |
|
join elimination is not sensitive to predicate order |
QKSFM_TABLE_ELIM_10232225 |
609 |
10232623 |
1 |
11.2.0.3 |
|
support bind peeking at subpartition level in kkpapDIGetRange() |
QKSFM_PARTITION_10232623 |
610 |
10271790 |
1 |
11.2.0.3 |
|
FKR: do not switch to Amode in presence of OBY/GBY and rownum |
QKSFM_FIRST_ROWS_10271790 |
611 |
10298302 |
1 |
11.2.0.3 |
|
use larger round robin cnt & buffers for random local distributi |
QKSFM_DML_10298302 |
612 |
10330090 |
1 |
11.2.0.3 |
|
allow min/max optimization in presence of constant predicates |
QKSFM_CBO_10330090 |
613 |
10333395 |
1 |
11.2.0.3 |
|
handle empty string with simplification of NVL |
QKSFM_CBO_10333395 |
614 |
10336499 |
0 |
|
|
adjust density to data dictionary value on gathering statistics |
QKSFM_CBO_10336499 |
615 |
10348427 |
1 |
11.2.0.3 |
|
use heap sort in kkeOrderPredArr() |
QKSFM_CBO_10348427 |
616 |
10359631 |
1 |
11.2.0.1 |
|
Virtual column replacement for connect by and ansi join queries |
QKSFM_CBO_10359631 |
617 |
10376744 |
1 |
11.2.0.3 |
|
use actual partition count when pruning to more than one partiti |
QKSFM_PARTITION_10376744 |
618 |
10420220 |
1 |
11.2.0.3 |
|
allow more OLAP tf view merging by disabling nnonfunc test |
QKSFM_SVM_10420220 |
619 |
10428278 |
1 |
11.1.0.6 |
|
Skip index heuristic for JPPD in case of PBY |
QKSFM_JPPD_10428278 |
620 |
10428450 |
1 |
8.0.0 |
|
distinguish range and hash keys for clumping decisions |
QKSFM_PQ_10428450 |
621 |
10623119 |
1 |
11.2.0.3 |
|
adjust for the number of nulls when computing OR selectivity |
QKSFM_CARDINALITY_10623119 |
622 |
10640430 |
1 |
8.0.0 |
|
Do not recursively parse (reproduce plans) under slave SQL |
QKSFM_SQL_PLAN_MANAGEMENT_10640430 |
623 |
11657468 |
1 |
11.2.0.3 |
|
disable ACS checks after many executions |
QKSFM_CURSOR_SHARING_11657468 |
624 |
11668189 |
1 |
11.2.0.3 |
|
parallelize top-level union all if PDDL or PDML |
QKSFM_PQ_11668189 |
625 |
11676888 |
0 |
|
|
compute avg col length for LONG RAW column |
QKSFM_STATS_11676888 |
626 |
11699884 |
1 |
11.2.0.3 |
|
fix selectivity of Table Lookup By NL view and dimensions |
QKSFM_STAR_TRANS_11699884 |
627 |
11720178 |
1 |
11.2.0.3 |
|
Enhance inline view merging security checks for PL/SQL functions |
QKSFM_TRANSFORMATION_11720178 |
628 |
11738631 |
1 |
11.2.0.3 |
|
Fixed andp visit of qksopSetHighLogExp in kketac() |
QKSFM_CBO_11738631 |
629 |
11740670 |
1 |
11.2.0.3 |
|
allow CBQT if all WITH views are inlined |
QKSFM_TRANSFORMATION_11740670 |
630 |
11741436 |
1 |
11.2.0.3 |
|
support binds in ORDER BY sort elimination with OR expansion |
QKSFM_OR_EXPAND_11741436 |
# |
Fix ID |
Value1 |
Optimizer Feature Enable2 |
Event |
Description |
SQL Feature ID |
631 |
11744086 |
1 |
11.2.0.3 |
|
skip SCG for query block with no aggregating columns |
QKSFM_PLACE_GROUP_BY_11744086 |
632 |
11814265 |
1 |
11.2.0.3 |
|
ref-part table transitive pruning |
QKSFM_PARTITION_11814265 |
633 |
11814428 |
1 |
11.2.0.3 |
|
use union all view stats for colgroup cardinality sanity check |
QKSFM_CARDINALITY_11814428 |
634 |
11830663 |
1 |
11.2.0.3 |
|
disallow HASH GROUP BY for subquery (in SELECT) processing |
QKSFM_COMPILATION_11830663 |
635 |
11834739 |
1 |
11.2.0.3 |
|
adjust NDV for list partition key column after pruning |
QKSFM_CBO_11834739 |
636 |
11843512 |
1 |
11.2.0.3 |
|
null value is not accounted in NVL rewrite |
QKSFM_CBO_11843512 |
637 |
11846314 |
1 |
8.0.0 |
|
no decrypt-to-encrypt for subquery column in GROUP BY and HAVING |
QKSFM_UNNEST_11846314 |
638 |
11853331 |
1 |
11.2.0.3 |
|
amend index cost compare with inlists as filters |
QKSFM_CBO_11853331 |
639 |
11876260 |
1 |
11.2.0.3 |
|
use index filter inlists with extended statistics |
QKSFM_CARDINALITY_11876260 |
640 |
11877160 |
1 |
11.2.0.3 |
|
conservatively allocate an ITL/distinct act txn for PDML |
QKSFM_DML_11877160 |
641 |
11881047 |
1 |
11.2.0.3 |
|
non top-level union is parallel if at least one branch is parall |
QKSFM_PQ_11881047 |
642 |
11892888 |
1 |
11.2.0.3 |
|
do not reset column stats when table stats not yet loaded |
QKSFM_CARDINALITY_11892888 |
643 |
11935589 |
1 |
8.0.0 |
|
allow merging views with materialized query blocks |
QKSFM_TRANSFORMATION_11935589 |
644 |
12315002 |
1 |
11.2.0.3 |
|
use extended statistics for DISTINCT cardinality estimates |
QKSFM_CBO_12315002 |
645 |
12348584 |
1 |
11.2.0.3 |
|
disable GBP for lateral oqb with disjunction |
QKSFM_PLACE_GROUP_BY_12348584 |
646 |
12352373 |
1 |
11.2.0.3 |
|
having subquery from any to single-row |
QKSFM_TRANSFORMATION_12352373 |
647 |
12399886 |
1 |
11.2.0.3 |
|
update the index clustering factor (DS) if statistics do not exi |
QKSFM_DYNAMIC_SAMPLING_12399886 |
648 |
12410972 |
1 |
11.2.0.3 |
|
push predicate with NLS_SORT in window function |
QKSFM_FILTER_PUSH_PRED_12410972 |
649 |
12432089 |
1 |
8.0.0 |
|
share PQ cursors for dbms_stats queries |
QKSFM_CURSOR_SHARING_12432089 |
650 |
12432426 |
1 |
11.2.0.3 |
|
Improve selectivity of predicates using CASE |
QKSFM_CBO_12432426 |
651 |
12584007 |
1 |
11.2.0.3 |
|
disable index-only costing for row versions table |
QKSFM_CBO_12584007 |
652 |
12591120 |
1 |
11.2.0.3 |
|
check inlist out-of-range values with extended statistics |
QKSFM_CBO_12591120 |