Question: what is the difference between a global secondary index and a local secondary index?
Answer: A global secondary index is considered "global" because queries on the index can span all of the data in the base table, across all partitions. ... A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the same partition key value.