Question
Range-based versus hashed sharding: how do distribution and query targeting differ?
Answer
Range sharding preserves shard-key order, enabling targeted range queries but risking hot ranges. Hashed sharding randomizes distribution, improving write spread but limiting range targeting. Use the form aligned with dominant access patterns. Applies to self-managed MongoDB and Atlas.