[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:
Duplicate
duplicates SERVER-32549 allow $expr with $in expression use a... Backlog
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

Generated at Thu Feb 08 04:48:04 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.