Amazon DocumentDB (with MongoDB compatibility) introduces new query planner that delivers up to 10x performance improvements

Amazon DocumentDB introduces a new query planner (NQP) delivering up to 10x performance improvements through enhanced cost estimation and optimized algorithms.

• Supports index scans for negation operators: $nin, $ne, $not
• Enables index usage for $type, nested $elemMatch, and $regex prefix searches
• Uses partial/sparse indexes without requiring $exists clause in queries
• Improves multi-key index performance with equality conditions
• Optimizes $in queries with compound indexes by eliminating sort stage
• Adds plan cache filter feature for server-side query hints without code changes
• Requires Engine Patch Version 3.0.15902 or later on DocumentDB 5.0
• Enable by setting planner_version parameter to 2.0 in cluster parameter group

The new query planner significantly improves DocumentDB performance for complex queries and large-scale operations through smarter index selection and optimized query execution.