Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
None
-
None
-
Query Optimization
-
(copied to CRM)
Description
The logic to strip invalid assignments of predicates to partial indexes is unaware of the contained-$or pushdown optimization. The analysis of which tags need to be stripped due to the partial index filter happens before any code relating to the contained-$or pushdown optimization. In order to fix this, we need to somehow make the index selection logic for partial indexes aware of the contained-$or pushdown optimization.