Local indexes in Phoenix
You can use local indexes for WRITE-heavy use cases. Each local indexes is stored within the data table.
With global indexes, you can use local indexes even when all columns referenced in a query are not contained in the index. This is done by default for local indexes, because the table and index data resides on the same region server and hence it ensures that the lookup is local.