Today, Amazon DocumentDB (with MongoDB compatibility) announces a new query planner, featuring advanced query optimization capabilities and improved performance. PlannerVersion 2.0 for Amazon DocumentDB (with MongoDB compatibility) 5.0 delivers up to 10x performance improvement over the prior version when using find and update operators with indexes. Performance improvements primarily come from using more optimal index plans and enabling index scan support for operators such as negation operators ($neq, $nin) and nested $elementMatch. PlannerVersion 2.0 queries run faster through better cost estimation techniques, optimized algorithms, and enhanced stability.
PlannerVersion 2.0 also simplifies query syntax. For example, you no longer need to provide explicit hints for $regex queries to utilize indexes.
PlannerVersion 2.0 is available in all AWS Regions where Amazon DocumentDB 5.0 is supported. You can enable it by simply modifying the corresponding parameter in your cluster parameter group. The change does not require a cluster restart or cause any downtime. If needed, you can easily revert to using the legacy query planner. To learn more about the new query planner, see Getting Started with New Query Planner.
Categories: general:products/amazon-documentdb,marketing:marchitecture/databases
Source: Amazon Web Services
Latest Posts
- Dynamics 365, Power Platform, and Role-based Copilot offerings 2026 release wave 1 plans available now [MC1255714]
- Dynamics 365 Customer Service – Define critical questions in evaluation criteria [MC1255709]
- Microsoft Copilot Studio – Read only Analytics Viewer role [MC1255508]
- Amazon SageMaker Unified Studio adds custom metadata filters
![(Updated) Microsoft Teams: Support for making a silent test call [MC1089323]](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-pixabay-356036-150x150.webp "(Updated) Microsoft Teams: Support for making a silent test call [MC1089323] 6")
![(Updated) Configure and manage connected experiences with Edge Connected Feature Control (CFC) – Targeted Release [MC1176364]](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-japy-929032-150x150.webp "(Updated) Configure and manage connected experiences with Edge Connected Feature Control (CFC) – Targeted Release [MC1176364] 7")