[SERVER-79034] [CQF] Satisfy RemoveOrphansRequirement in ScanNode implementer Created: 17/Jul/23  Updated: 29/Oct/23  Resolved: 04/Aug/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0

Type: Task Priority: Major - P3
Reporter: Ben Shteinfeld Assignee: Richard Hausman (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Participants:

 Description   

In many cases, plans will have a SargableNode which will satisfy RemoveOrphansRequirement (SERVER-78507). However, plans without sargable predicates (or an empty query) may result in a full collection scan with a ScanNode without a SargableNode. This means we need ScanNode to be able to satisfy RemoveOrphansRequirement.

We could rely the existing enforcer for RemoveOrphansRequirement to generate a physical alternative, but this won't take advantage of the ability to push down top-level field projections into the physical scan.

We should take care to test dotted field paths.



 Comments   
Comment by Githook User [ 07/Aug/23 ]

Author:

{'name': 'Richard Hausman', 'email': 'richard.hausman@mongodb.com', 'username': 'rhausman'}

Message: SERVER-79034 Add Implementer for ScanNode that enforces RemoveOrphans requirement
Branch: minh.luu-no_compile_sys-perf
https://github.com/mongodb/mongo/commit/7d3620f267bab213beccbd240a6bd3c0deb89892

Comment by Githook User [ 04/Aug/23 ]

Author:

{'name': 'Richard Hausman', 'email': 'richard.hausman@mongodb.com', 'username': 'rhausman'}

Message: SERVER-79034 Add Implementer for ScanNode that enforces RemoveOrphans requirement
Branch: master
https://github.com/mongodb/mongo/commit/7d3620f267bab213beccbd240a6bd3c0deb89892

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