Last active
December 2, 2025 02:09
-
-
Save JenHsuan/305818f211380976bffab56b1687a109 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LSI | GSI | ||
|---|---|---|---|
| Across partitions | x | o | |
| Key | Alternatively Sort key (same Partition key as that of base table) | Alternatively Primary key (hash or hash + range) and sort key | |
| Created Time | Must be defined at table creation time | Can be added/modified after table creation | |
| Read/Write Support | Support Eventual consistency/Strongly consistency | Only support Eventual consistency | |
| RCU & WCU | Use the RCU & WCU of the main table | Must provision RCU & WCU for the index | |
| Throttling consideration | No special consideration | The provisioned WCU for a GSI should be equal or greater than the WCU of the base table | |
| Attribute Projections | some or all attributes of the base table | some or all attributes of the base table | |
| Limitation | Up to 5 LSI per table | Up to 20 GSI per table |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment