[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:
Related
related to SERVER-36202 when creating new index, use existing... Closed
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.

Generated at Thu Feb 08 05:25:32 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.