[SERVER-38138] $expr doesn't use indexes Created: 14/Nov/18 Updated: 15/Nov/18 Resolved: 15/Nov/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 4.0.4 |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Hawk Kero | Assignee: | Danny Hatcher (Inactive) |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Description |
|
$expr doesn't use indexes at all with any expression, except with $eq and this happened after it was issued https://jira.mongodb.org/browse/SERVER-33364 My issue specifically with $in, neither in $lookup nor in find() it uses indexes even on _id field |
| Comments |
| Comment by Danny Hatcher (Inactive) [ 15/Nov/18 ] |
|
Hello, This is a known issue as referenced in SERVER-32549. I encourage you to watch that ticket for any updates. Thank you, Danny |