Best practices for using secondary indexes in DynamoDB

Secondary indexes are often essential to support the query patterns that your application requires. At the same time, overusing secondary indexes or using them inefficiently can add cost and reduce performance unnecessarily.

Contents

• General guidelines for secondary indexes in DynamoDB

  • Use indexes efficiently

  • Choose projections carefully

  • Optimize frequent queries to avoid fetches

  • Be aware of item-collection size limits when creating local secondary indexes

• Take advantage of sparse indexes

  • Examples of sparse indexes in DynamoDB

• Using Global Secondary Indexes for materialized aggregation queries in DynamoDB

  • Example scenario and access patterns

  • Why pre-compute aggregations

  • Table design

  • Aggregation pipeline with Streams and AWS Lambda

  • Sparse GSI design

  • Querying the GSI

  • Considerations

• Overloading Global Secondary Indexes in DynamoDB

• Using Global Secondary Index write sharding for selective table queries in DynamoDB

  • Pattern design

  • Sharding strategy

  • Querying the sharded GSI

  • Parallel query execution considerations

  • Code example

• Using Global Secondary Indexes to create an eventually consistent replica in DynamoDB