Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/MongoDB
MongoDBhard

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

Tags
#mongo#sharding#shard-key#performance
Back to categoryPractice quiz

Answer

If a query doesn’t include the shard key (or its useful prefix), `mongos` may have to ask many shards and merge results (“scatter-gather”), which increases latency and load. You avoid it by choosing a shard key that matches your common query patterns and by ensuring queries include it.

Related questions

MongoDB
Unique vs sparse vs partial indexes: what’s the difference?
#mongo#indexes#unique
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
Replica set elections: what happens during an election?
#mongo#replica-set#election
MongoDB
Read preference in replica sets: what does `primary` vs `secondary` mean?
#mongo#replica-set#read-preference
MongoDB
Read concern vs write concern: what do they control?
#mongo#consistency#read-concern