Loading...

XML

Word

Printable

JSON

Hello,

When using $expr, a query that should be covered by the index actually examine documents.

Not only that, it searches for the values twice, once during the index scan and a second time during the fetch stage.

is duplicated by

SERVER-83529 Generate covered projections with $expr

SERVER-96826 $expr with find() does not use an index

is related to

SERVER-41171 MongoDB $lookup using "$expr" is slow compared to simple $lookup

SERVER-106505 $sequentialCache optimization can interfere with $match pushdown in a $lookup sub-pipeline

SERVER-96826 $expr with find() does not use an index

Assignee:: Milena Ivanova
Reporter:: Miguel Ángel Nieto
Participants:: Asya Kamsky, Craig Homa, Ivan Fefer, Miguel Ángel Nieto, Milena Ivanova
Votes:: 5 Vote for this issue
Watchers:: 25 Start watching this issue