[DOCS-15714] [Server]: Add time-series bounded collection scan plans to query multi-planner Created: 02/Nov/22  Updated: 13/Nov/23  Resolved: 09/Oct/23

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 6.2.0-rc0, 6.0.7, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Lauren Tran
Resolution: Done Votes: 0
Labels: query, server-docs-bug-bash
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-58276 Add time-series bounded collection sc... Closed
Participants:
Days since reply: 1 year, 14 weeks ago

 Description   
Original Downstream Change Summary

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.



 Comments   
Comment by Education Bot [ 02/Nov/22 ]

Fix Version updated for upstream SERVER-58276:
6.2.0-rc0

Generated at Thu Feb 08 08:13:38 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.