Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: None
Affects Version/s: None
Component/s: Index Maintenance
Labels:
- pmr

Assigned Teams:

Storage Execution
Sprint:
Execution Team 2020-10-05
Confidence Status:
None
Work Order:
3

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name:
None
Goal Link:
None

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

(2 is related to)

Assignee:: Unassigned
Reporter:: Asya Kamsky
Participants:: Asya Kamsky, Daniel Gottlieb, Louis Williams, Steven Vannelli
Votes:: 0 Vote for this issue
Watchers:: 16 Start watching this issue

Created:: Jul 19 2018 08:01:58 PM UTC
Updated:: Jul 30 2024 03:43:04 PM UTC

Details

Description

Attachments

Issue Links

Activity

People

Dates