[SERVER-63500] Optimize the full index scan when converting an index to unique through collMod Created: 09/Feb/22 Updated: 05/Jun/23 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Yuhong Zhang | Assignee: | Backlog - Storage Execution Team |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | neweng, techdebt | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Storage Execution
|
||||||||
| Participants: | |||||||||
| Description |
|
While the current performance is good for the use case of 6.0, there are several things that can be cleaned up to make the loop scanning the index more efficient. For example: using the SortedDataInterface::Cursor directly instead of with DataThrottle; making sure we're not doing extra copies; using simpler data structures, etc. |