[SERVER-83287] Ixscan plans on unique indexes needlessly call next() on storage cursor Created: 15/Nov/23  Updated: 25/Jan/24  Resolved: 17/Jan/24

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

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Zixuan Zhuang
Resolution: Fixed Votes: 0
Labels: auto-reverted, query-perf-q4
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Related
is related to SERVER-85577 Missing fields in KeyString cause inc... Closed
is related to SERVER-85727 [v7.3] Revert "Ixscan plans on unique... Closed
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Participants:
Linked BF Score: 154

 Description   

When we make an index scan SBE plan with point bounds, we end up calling next() in the storage layer more than once, even though a unique index guarantees that there can only be one key. We should consider optimizing this.



 Comments   
Comment by Githook User [ 25/Jan/24 ]

Author:

{'name': 'Zixuan', 'email': 'leozzx@users.noreply.github.com', 'username': 'leozzx'}

Message: SERVER-85727 Revert "SERVER-83287 Avoid unnecessary next() call on unique indexes … (#18388)

GitOrigin-RevId: eacfd09bc2bca2abc0206dba154c23029fe08558
Branch: v7.3
https://github.com/mongodb/mongo/commit/f146aeefe0010b422e68c12988d2917cbc95e49f

Comment by Githook User [ 17/Jan/24 ]

Author:

{'name': 'Zixuan', 'email': 'leozzx@users.noreply.github.com', 'username': 'leozzx'}

Message: SERVER-83287 Avoid unnecessary next() call on unique indexes for SBE (#18084)

GitOrigin-RevId: 7fdf7fe84fb9b8cc8504b63b2a4ae0836c9d320f
Branch: master
https://github.com/mongodb/mongo/commit/e9579d48a1c71c2884f66023e53c5207324d358d

Comment by Githook User [ 11/Jan/24 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-83287 Avoid unnecessary next() call on unique indexes for SBE (#17814)"

This reverts commit 88cd25c553792dd4cbd07c139a616eff7fcdf90c.

GitOrigin-RevId: 2bcfeb7bb5ced13bee74d6a064b2c2dafb540809
Branch: master
https://github.com/mongodb/mongo/commit/678eb0dcd2a0e037d172971054f1f63b8cb31bd2

Comment by Githook User [ 10/Jan/24 ]

Author:

{'name': 'Zixuan', 'email': 'leozzx@users.noreply.github.com', 'username': 'leozzx'}

Message: SERVER-83287 Avoid unnecessary next() call on unique indexes for SBE (#17814)

GitOrigin-RevId: 88cd25c553792dd4cbd07c139a616eff7fcdf90c
Branch: master
https://github.com/mongodb/mongo/commit/d3c6e9f5862c53a90b622ddb19eecd6fc001e12f

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