-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Index Maintenance
-
Storage Execution
-
Execution Team 2020-10-05
A user pointed out that if there is an index on a:1, b:1 and they specify they want to create a new index b:1 with partialFilterExpression:{a:10} (or any other filter on a then index build could scan the existing index and build new index much faster.
Common use case that can benefit from this may also be a case where there exists an index on a:1, b:1, c:1 and user wants to replace it with index on just a:1, b:1 which again can be build (hopefully) faster from existing index than collection scan.
- is duplicated by
-
SERVER-48697 Create new index base on existing ones
- Closed
- is related to
-
SERVER-3150 Allow creation of sparse index over a regular index
- Closed
-
SERVER-51458 Allow creation of a partial index using an existing index
- Closed
-
SERVER-51459 Allow creation of index based on secondary fields of existing compound index
- Closed
-
SERVER-51460 Investigate supporting creation of indexes with different collations based on an existing index
- Closed
-
SERVER-51461 Support building indexes from existing indexes guarded by feature flag
- Closed
-
SERVER-51466 Investigate support for building a multikey index from an existing multikey index
- Closed