-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
ALL
-
In the cases where the index bounds are a transformation of the original bounds, the estimate is zero as the transformed bounds can never be found in the histogram. Cases include:
- hashed indexes
indexBounds: { a: [ '[5902408780260971510, 5902408780260971510]' ] }
- collations:
indexBounds: { a: [ '[CollationKey(0x3d0105), CollationKey(0x3d0105)]' ] }
Timour enumerated the following 3 potential solutions:
- Do not use histogram CE when the index bounds are transformed (e.g. hashed) constants
- Store the original bounds in the interval
- Establish equivalence of interval and predicate, and use the constant from the predicate when the bounds are transformed
- duplicates
-
SERVER-97373 Fallback to multiplanning for unsupported collection and index scans
-
- Closed
-
- is related to
-
SERVER-97373 Fallback to multiplanning for unsupported collection and index scans
-
- Closed
-