MongoDBmedium

What is a projection in MongoDB and why use it?

Answer

Projection means selecting only specific fields to return (include/exclude). It reduces payload size, improves performance, and avoids leaking unnecessary data.

db.users.find(
  { active: true },
  { email: 1, name: 1, _id: 0 }
)

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