[SERVER-71040] Investigate remaining index scan regressions Created: 02/Nov/22  Updated: 29/Oct/23  Resolved: 16/Feb/23

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

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Drew Paroski
Resolution: Fixed Votes: 0
Labels: pm2697-63, pm2697-m3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-70054 [SBE] Investigate regression in Queri... Closed
Problem/Incident
Related
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-02-06, QE 2023-02-20
Participants:
Linked BF Score: 5
Story Points: 10

 Description   
Queries.RangeQuery_CompoundIndex_ComplexBounds_ThreeFields_LS
Queries.RangeQuery_CompoundIndex_ComplexBounds_TwoFields_LS
Queries.RangeQuery_MultipleIndexes_LowSelectivityMatch_LL
Queries.RangeQuery_SingleFieldIndex_ComplexBounds_LS
Queries.RangeQuery_SingleIndex_SimpleRange_LowSelectivityMatch_LS
Queries.WildcardIndex.PointQueryOnSingleArrayField.Baseline -10.44715325


 Comments   
Comment by Githook User [ 16/Feb/23 ]

Author:

{'name': 'Drew Paroski', 'email': 'drew.paroski@mongodb.com', 'username': 'paroski'}

Message: SERVER-71040 Improve how we generate SBE plans involving index scans
Branch: master
https://github.com/mongodb/mongo/commit/3894b879a88f7bec2ea1fa886cb593189ef70ceb

Comment by Zixuan Zhuang [ 02/Dec/22 ]

The latest number as of 12/2/22:

test percentage_change percent_change_stable
Queries.RangeQuery_CompoundIndex_ComplexBounds_ThreeFields_LS -2.967 -5.996
Queries.RangeQuery_CompoundIndex_ComplexBounds_TwoFields_LS -5.605 -7.15
Queries.RangeQuery_MultipleIndexes_LowSelectivityMatch_LL -10.423 -10.635
Queries.RangeQuery_SingleFieldIndex_ComplexBounds_LS -10.714 -10.543
Queries.RangeQuery_SingleIndex_SimpleRange_LowSelectivityMatch_LS 4.406 2.742
Queries.WildcardIndex.PointQueryOnSingleArrayField.Baseline -4.77 -6.288
Generated at Thu Feb 08 06:17:53 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.