Database Reference
In-Depth Information
Parameter
Local secondary index
Global secondary index
Consistency
Provides option to select either eventual or
strong consistency.
Supports only eventual consistency.
The size of all items together for a single index
should be less than 10 GB per hash key.
Size
No size limit.
Provisioned
throughput
Uses the same provisioned throughput as speci-
fied for a table.
Has a different calculation for provisioned throughput. We need to specify the
read and write capacity units at the time of index creation itself.
There is no argument whether the global secondary index is better or the local secondary
index. It totally depends upon what use case you have. So if you know the access pattern
of your application, it would not take much time to decide which index to use and which
one not to.
