-
Type: New Feature
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Index Maintenance, Querying
-
None
-
Fully Compatible
-
Execution Team 2021-02-22, Execution Team 2021-03-08
Modify the query system to perform bounded collection scans over _id ranges given a start and end key. Allow the CollectionScan stage to perform bounded collection scans over _id ranges given a start and end key. This will allow $gt(e) and $lt(e) range queries by _id to go directly to the record store. An additional option to delete records in these ranges is necessary for TTL deletions.
- depends on
-
SERVER-53989 The RecordStore needs to determine its RecordId type via the durable catalog metadata
- Closed
- is depended on by
-
SERVER-54654 ephemeralForTest oplogStartHack does not consider oplog visibility
- Closed
-
SERVER-54007 Perform TTL deletions on clustered indexes
- Closed
-
SERVER-54398 Extend query planner to generate bounded collection scan plans for time series collections
- Closed
- related to
-
SERVER-54409 Extend SBE stage builder to support bounded collection scans for time series collections
- Closed
-
SERVER-54715 Trim predicates off CollectionScanNode if they are expressible directly as bounds on RecordStore's primary key
- Backlog
-
SERVER-54969 Collection scan bounds for clustered collections should allow for exclusivity
- Backlog