[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: |
|
||||||||||||||||||||
| 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. |