[SERVER-82053] Use index hint for time series bucket reopening query Created: 10/Oct/23 Updated: 08/Feb/24 Resolved: 26/Jan/24 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 8.0.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Dan Larkin-York | Assignee: | Dan Larkin-York |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | bkp | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Assigned Teams: |
Storage Execution
|
||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||
| Backport Requested: |
v7.0
|
||||||||||||||||
| Sprint: | Execution Team 2023-11-27, Execution Team 2023-12-11, Execution Team 2023-12-25, Execution Team 2024-01-22, Execution Team 2024-02-05 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Linked BF Score: | 155 | ||||||||||||||||
| Description |
|
While we disable query-based reopening if a sufficient index does not exist, we currently do not specify an index hint when we do choose to run the query. Under some circumstances, the query planner may fail to use the appropriate index, resulting in a collection scan. |
| Comments |
| Comment by Githook User [ 08/Feb/24 ] |
|
Author: {'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}Message: (cherry picked from commit b6484345740910793809ba655a62eeabda1f319b) GitOrigin-RevId: 323f3cfdb6f095a97501b7866447ac488132e97a |
| Comment by Githook User [ 25/Jan/24 ] |
|
Author: {'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}Message: GitOrigin-RevId: b6484345740910793809ba655a62eeabda1f319b |
| Comment by Githook User [ 29/Nov/23 ] |
|
Author: {'name': 'Gregory Wlodarek', 'email': 'gregory.wlodarek@mongodb.com', 'username': 'GWlodarek'}Message: Revert " This reverts commit ea5336dd3fe4dd481d2c991b3bdd2f01e5593657. |
| Comment by Githook User [ 27/Nov/23 ] |
|
Author: {'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}Message: |