[DOCS-10681] Aggregation Pipeline Behavior does not mention index usage for $lookup and $graphLookup Created: 16/Aug/17  Updated: 30/Oct/23

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Task Priority: Major - P3
Reporter: Stennie Steneker (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
Participants:
Days since reply: 1 year, 14 weeks, 2 days ago
Epic Link: DOCSP-1769
Story Points: 0.5

 Description   

The Aggregation Pipeline Behavior page does not include mention of potential index usage by $lookup and $graphLookup.

Both can take advantage of indexes.



 Comments   
Comment by Education Bot [ 31/Oct/22 ]

Hello! This ticket has been closed due to inactivity. If you believe this ticket is still important, please reopen it and leave a comment to explain why. Thank you!

Comment by Stennie Steneker (Inactive) [ 16/Aug/17 ]

As at MongoDB 3.4, the $lookup will be an equality query of the form:

{ <foreignField> : { $eq: <localField value> } }

on the <from> collection for each source document.

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