Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: Querying
Labels:
- bonsai
- storch

Assigned Teams:

Query Optimization
Sprint:
Query 2017-10-23, Query 2017-11-13, Query 2017-12-04, Query 2017-12-18, Query 2018-01-01, Query 2018-01-15
Case:
Confidence Status:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name:
None
Goal Link:
None

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

Assignee:: [DO NOT USE] Backlog - Query Optimization

Reporter:: David Storch

Participants:: [DO NOT USE] Backlog - Query Optimization, Daniel Pasette, David Storch, Evan Worley, Ian Whalen, J Rassi, Justin Seyster

Votes:: 5 Vote for this issue

Watchers:: 34 Start watching this issue

Created:: Jun 01 2015 03:47:09 PM UTC

Updated:: May 31 2024 10:05:19 PM UTC

Confidence Status Last Update:: 12/Jan/18 4:42 PM

Details

Description

Attachments

Issue Links

Activity

People

Dates