[SERVER-51458] Allow creation of a partial index using an existing index Created: 09/Oct/20 Updated: 30/May/23 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Louis Williams | Assignee: | Backlog - Storage Execution Team |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Storage Execution
|
||||||||
| Participants: | |||||||||
| Description |
|
With an existing index on {a: 1, b: 1}, support building a new index {a: 1} with a partialFilterExpression on a or b. In this same example, we do not intend to support creating a new index {a: 1} with a partialFilterExpression on fields other than a or b. |
| Comments |
| Comment by Irwin Dolobowsky [ 19/Apr/23 ] |
|
We're looking at numerous indexing improvements, including using the same design as for Adding a Shard where we read and only copy the necessary items to a new index. I think that option would overrride the need for this, or essentially fulfill this direction. Putting in the backlog to until it that other work is evaluated and decided upon. |