-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
v9.0, v8.3
-
None
-
None
-
None
-
None
-
None
-
None
-
None
In some cases the sampling is insufficient to determine the proper CE of a predicate. This can be the case for highly selective predicates on large collections or simply a "bad" sample. This ticket should implement a fallback into MP in the case of a 0 estimate instead of using heuristics.
- is related to
-
SERVER-133442 In the case of zeroCE, do not fail CBR if we are doing join optimization
-
- Needs Scheduling
-
-
SERVER-133405 Add a dedicated plan ranker 'reason' for zero CE fallback
-
- Needs Scheduling
-
- related to
-
SERVER-132698 Make "prefer shorter indexes" code take presence of index bounds into account
-
- Needs Scheduling
-