Secondary Indexes

Master the art of querying DynamoDB beyond the Primary Key. Learn to use Global Secondary Indexes (GSI) for scale, Local Secondary Indexes (LSI) for strong consistency, and advanced patterns like Index Overloading and Sparse Indexes.

Module Contents

1. LSI vs GSI

Comprehensive guide to Secondary Indexes. Covers GSI basics, the 10GB LSI limit, and critical Projection Strategies (KEYS_ONLY vs INCLUDE vs ALL).

2. Overloaded GSI

Learn the “Swiss Army Knife” of DynamoDB modeling: using a single GSI to support multiple access patterns and entity types.

3. Sparse Indexes

Optimize costs and performance by indexing only a subset of your data. Perfect for filtering and “needle in a haystack” queries.

Review & Cheat Sheet

Test your knowledge with interactive flashcards and grab the quick reference cheat sheet.