[SERVER-3150] Allow creation of sparse index over a regular index Created: 26/May/11  Updated: 20/Nov/23  Resolved: 20/Nov/23

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: 1.8.1
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Jeffrey Yemin Assignee: Backlog - Storage Execution Team
Resolution: Won't Do Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
related to SERVER-36202 when creating new index, use existing... Closed
Assigned Teams:
Storage Execution
Participants:

 Description   

Currently, if you already have a regular index for a given field, there is no way to make it sparse without first deleting the regular index.
But this is painful when upgrading from 1.6.x, because during the time that the sparse index is being created all your queries that rely on that index become table scans.

Would be better if there was a way to replace an existing index with a sparse one with no time during which neither index is usable.



 Comments   
Comment by Steven Vannelli [ 20/Nov/23 ]

Closing out as Won't Do since there isn't enough product motivation.

Generated at Thu Feb 08 03:02:13 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.