AWS Certified Data Analytics Specialty 2021 – Hands-On - DynamoDB Indexes (GSI + LSI)

The video tutorial explains two types of indexes in databases: Local Secondary Indexes (LSI) and Global Secondary Indexes (GSI). LSIs provide an alternative sort key while maintaining the same partition key, and must be defined at table creation. GSIs offer a different primary key and can be added or modified post table creation. The tutorial includes examples of using LSIs and GSIs for querying, and discusses throttling considerations, emphasizing careful planning of index and capacity settings.

Describe how the attributes of a GSI can differ from those of the main table.

What are the implications of throttling on a Global Secondary Index (GSI)?