After SERVER-54398, queries on time-series collections will only consider a bounded collection scan when no indexed solution is available. However there are cases where the bounded collection scan results in better performance than an indexed plan, for example when the indexed solution has wide index bounds and must fetch many documents. We should add the bounded collection scan as a potential plan and compare it with indexed solutions in the query multi-planning process.
- causes
-
SERVER-73423 CLUSTERED_IXSCAN with sort generates two duplicate plans
- Closed
- related to
-
SERVER-59341 Query planner choses collscan over covered index scan for huge collection
- Backlog
-
SERVER-54398 Extend query planner to generate bounded collection scan plans for time series collections
- Closed