[SERVER-77860] Consider storing clustered index scan plans in classic plan cache Created: 07/Jun/23  Updated: 25/Jan/24  Resolved: 25/Jan/24

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

Type: Improvement Priority: Major - P3
Reporter: Arun Banala Assignee: Militsa Sotirova
Resolution: Gone away Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Optimization
Sprint: QO 2024-02-05
Participants:

 Description   

After SERVER-58276, we made clustered index scans eligible for multi-planning. This means that if there is a competing secondary index and clustered index performance better, we would be multi-planning for the same query every time the query is run. We should consider caching bounded collection scans to avoid this inefficiency


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