[SERVER-78044] Cache rooted $or queries that use clustered collection scans in SBE Created: 13/Jun/23  Updated: 14/Jun/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Gil Alon Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-61259 $or queries with text indexes fail on... Closed
is related to SERVER-77280 $or queries only produce collscan for... Closed
Assigned Teams:
Query Execution
Participants:

 Description   

SERVER-77280 introduced plans that can have multiple clustered collection scans, but a bug was discovered with the SBE plan cache and SERVER-61259 disabled plans with OR stages and clustered collection scan stages from being cached. We should investigate how to best bind the parameters and retrieve these parameters from the SBE cache.


Generated at Thu Feb 08 06:37:19 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.