Glossary: System Design Beyond the Basics

Local / global index

Also written: Local index, global index

A local secondary index is kept per partition: writes stay on one shard but a query asks every shard. A global index is partitioned by the indexed value: a query asks one place, but a write touches two shards and the index can lag.