Articles → AWS → Difference Between The Global Secondary Index And The Local Secondary Index In Dynamodb

Difference Between The Global Secondary Index And The Local Secondary Index In Dynamodb

In this article, we will discuss the difference between the Global Secondary Index and the Local Secondary Index in DynamoDB.

Scope

Global Secondary Index (GSI) spans the entire table

Local Secondary Index (LSI) is limited to items within a specific partition

Partition And Sort Keys

Global Secondary Index (GSI) has its own partition key and sort key

Local Secondary Index (LSI) shares the partition key with the table and has its own sort key

Write And Read Throughput

Global Secondary Index (GSI) provisioned its own read and write capacity

Local Secondary Index (LSI) shares the read and write throughput with the table

Consistency

Global Secondary Index (GSI) provides eventual consistency for read operations by default, but you can choose strongly consistent reads

The Local Secondary Index (LSI) supports both eventual and strongly consistent reads

Creation And Deletion

Global Secondary Index (GSI) can be created or deleted at any time

The Local Secondary Index (LSI) must be defined when creating the table and you cannot add or remove LSIs after table creation

Posted By -	Karan Gupta

Posted On -	Thursday, November 16, 2023

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**