[SERVER-6095] make multikey indices useful for sharding Created: 14/Jun/12  Updated: 10/Dec/14  Resolved: 02/May/14

Status: Closed
Project: Core Server
Component/s: Index Maintenance, Sharding
Affects Version/s: 2.1.2
Fix Version/s: None

Type: Improvement Priority: Minor - P4
Reporter: Kevin Matulef Assignee: Randolph Tan
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-1506 when sharding on a and need an index ... Closed
Duplicate
duplicates SERVER-9620 Index can be made multikey if a prefi... Closed
is duplicated by SERVER-6493 Inserting array value for non-shard-k... Closed
Participants:

 Description   

If sharding on "a", an index on "a,b" is not considered useful if there are multikey (array) values for "b". Theoretically, it should still be useful (though maybe less efficient than single-key indices), so we should be able to use it if no single-key index that start with "a" exists.


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