Our Blog

Amazon DocumentDB (with MongoDB compatibility) announces upgraded query planner that can run queries up to 10x faster

Published
October 28, 2025
https://aws.amazon.com/about-aws/whats-new/2025/10/new-query-planner

Amazon DocumentDB Query Planner Update

Amazon DocumentDB (with MongoDB compatibility) has introduced a new query planner, PlannerVersion 2.0, delivering up to 10x performance improvement over the prior version. This update features advanced query optimization capabilities and improved performance, particularly with find and update operators using indexes. Key enhancements include:

  • Optimal Index Plans: More efficient index plans.
  • Index Scan Support: Enabled for operators like $neq, $nin, and nested $elementMatch.
  • Better Cost Estimation: Improved techniques for query cost estimation.
  • Optimized Algorithms: Enhanced stability and performance.
  • Simplified Query Syntax: No need for explicit hints for $regex queries to utilize indexes.

What to do

  • Enable PlannerVersion 2.0 by modifying the parameter in your cluster parameter group.
  • No cluster restart or downtime is required.
  • Easily revert to the legacy query planner if needed.

Source: AWS release notes




If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.

Follow our blog

Get the latest insights and advice on AWS services from our experts.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Related posts

Check out other insights from the team at West Loop Strategy.

View all
https://aws.amazon.com/about-aws/whats-new/2025/10/generative-ai-observability-amazon-cloudwatch/

Generative AI observability now generally available for Amazon CloudWatch

Amazon CloudWatch announces the general availability of generative AI observability, helping you monitor all components of AI applications and workloads, including agents deployed and operated with Amazon Bedrock AgentCore
Read more
https://aws.amazon.com/about-aws/whats-new/2025/10/amazon-connect-outbound-campaigns-preview-dialing/

Amazon Connect outbound campaigns supports preview dialing for greater agent control

Amazon Connect outbound campaigns now offers a preview dialing mode that gives agents more context about a customer before placing a call
Read more
https://aws.amazon.com/about-aws/whats-new/2025/09/aws-firewall-manager-aws-asia-pacific-taipei-region

AWS Firewall Manager launches in AWS Asia Pacific (Taipei) Region

AWS Firewall Manager announces that it is now available in AWS Asia Pacific (Taipei) Region
Read more
View all