SERVER-136521ClosedFixed

Exclude sort and or from the 0-CE MP fallback

SERVER-136193 applies the 0-CE fallback in all cases when an index scan has a 0 inCE. This applies also to sort queries, and queries with an inner $or (under an $and). However, this results in quite a lot of regressions, because MP is not good at estimating such queries: # In plans with blocking sort CBR costs them, MP exhausts the budget without results and MP tie breaking heuristics pick a worse plan. # Plans with non-top-level $OR. MP favors the plan with the most productive left branc

Affected Versions
Versions known to exhibit this issue

No affected versions recorded.

Fixed Versions
Versions that include the fix
9.1.0-rc09.1.0-rc1024
Components
Server components related to this issue

No components specified.

Labels
Tags and classification

No labels assigned.