Question

What is the primary difference between a global secondary index and a local secondary index?

Answer 1

A global secondary index is considered "global" because queries on the index can span all of the data in a table, across all partitions. Local secondary index — an index that has the same hash key as the table, but a different range key.