MongoDBmedium

What does `$lookup` do in MongoDB aggregation (and what’s a caveat)?

Answer

`$lookup` joins documents from another collection (like a left join). Caveat: joins can be expensive at scale; make sure you have indexes on join keys and consider denormalization/embedding when appropriate.

Related questions

MongoDB

Text indexes: when would you use them and what’s a limitation?

#mongo#text-index#search

MongoDB

`$lookup`: what does it do and what is a common pitfall?

#mongo#lookup#aggregation

MongoDB

Sharded MongoDB balancing (chunk migrations): what can go wrong and how do you reduce impact?

#mongo#sharding#balancer

MongoDB

Aggregation pipeline performance: why put `$match` (and `$project`) early?

#mongo#aggregation#pipeline

MongoDB

What is a covered query in MongoDB and why can it be faster?

#mongo#indexes#covered-query

MongoDB

Sharded MongoDB: why are “scatter-gather” queries bad and how do you avoid them?

#mongo#sharding#shard-key