Details
-
Task
-
Status: Closed
-
Major - P3
-
Resolution: Fixed
-
None
-
None
-
3
-
ServerDocs2020: Mar16 - Mar23, ServerDocs2020: Mar23 - Mar30, ServerDocs2020: Mar30 - Apr06, ServerDocs2020: Apr6 - Apr13, ServerDocs2020: Apr13 - Apr20
Description
Description
As of this change, users can now create multiple partial indexes on the same key pattern so long as the partialFilterExpression fields do not express equivalent filters.
Description of Linked Ticket
If I have a large data set, I might want to create several indexes on it, each index covering only a subset of the full set of documents. Currently that's not allowed because we don't allow same pattern with different options, and filter is part of the options.
Scope of changes
Review and update the partial index restrictions in accordance with this new behavior. https://docs.mongodb.com/manual/core/index-partial/#restrictions
Impact to Other Docs
MVP (Work and Date)
Resources (Scope or Design Docs, Invision, etc.)
Attachments
Issue Links
- documents
-
SERVER-25023 no way to index the same fields with two different partial index filters
-
- Closed
-
- is related to
-
DOCS-14277 Investigate changes in SERVER-47657: Add 'unique' and 'sparse' parameters to index signature
-
- Closed
-