From the course: AWS for Developers: DynamoDB

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating secondary indexes in DynamoDB: GSI and LSI

Creating secondary indexes in DynamoDB: GSI and LSI - Amazon Web Services (AWS) Tutorial

From the course: AWS for Developers: DynamoDB

Start my 1-month free trial

Creating secondary indexes in DynamoDB: GSI and LSI

“

- [Instructor] One question you might have at this point is, sure, we can fetch data by partition key, but what happens when I need to get data by something other than the partition key? Let's look at a more complex scenario and talk about creating indexes to solve that problem. Through his career, a professional baseball player will most likely play for more than one team. As you saw in our previous video, we created a partition key based on the team abbreviation where we're logging our game stats. What if I do if I want to fetch data for a player for all of their teams? Well, this is where indexes come in in DynamoDB, and there are two kinds: local and global indexes. But before we get into that, let's look at how a traditional SQL index works. Here I have a standard SQL table logging game stats for a player. You'll see the primary key is a composite of the GameID, TeamID, as well as the PlayerID. Now, if I want to query this table by PlayerID, I need to create an index. The index…

Contents