Home icon

Improve query performance using partial indexes in Amazon DocumentDB

Database Blog

This article explains how to use partial indexes in Amazon DocumentDB to improve query performance and optimize database operations.

Specifically, the article covers:

  • Benefits of partial indexes, including improved query performance, smaller index size, selective uniqueness and deletion, and optimized write performance
  • How to create a partial index using the partialFilterExpression option
  • Use cases for partial indexes, such as querying a subset of data, combining multiple operators, using TTL indexes, and maintaining uniqueness in a collection
  • Examples of creating partial indexes for different scenarios
  • Conclusion highlighting the advantages of partial indexes in Amazon DocumentDB
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 19
2024
Unlock the power of parallel indexing in Amazon DocumentDB
Apr 15
2024
Reduce cost and improve performance by migrating to Amazon DocumentDB 5.0
Apr 16
2024
Scale write performance on Amazon DocumentDB elastic clusters
Jun 12
2024
Optimize costs with scheduled scaling of Amazon DocumentDB for read workloads

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.