-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Labels:
We now consider clustered index scan in multi planning if it can be used., so now it will compete with secondary indexes.
In previous versions we only considered clustered index scan if there is no secondary indexes or an explicit hint was given: https://www.mongodb.com/docs/manual/core/clustered-collections/#limitations
Description of Linked Ticket
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.
- documents
-
SERVER-58276 Add time-series bounded collection scan plans to query multi-planner
- Closed