Rooted $or queries run through the SubplanStage path. The SubplanStage may use a cached plan for a branch of the $or without making use of the CachedPlanStage trial period logic. This means that rooted $or queries could use badly performing plans without plan cache entry eviction and replanning kicking in.
- is related to
-
SERVER-13732 Predicates in top-level implicit AND query not considered when generating index access plan for contained OR
- Closed
-
SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly
- Closed
- related to
-
SERVER-19835 SubplanStage should not cache plan for an individual $or branch if plans tie or there are no query results
- Closed
-
SERVER-91095 Make cases where plan cache stores neither works nor reads more explicit
- Backlog