课程: AWS for Developers: DynamoDB

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Creating secondary indexes in DynamoDB: GSI and LSI

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

课程: AWS for Developers: DynamoDB

开始一个月试用 购买团队方案

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…

内容