Global indexes in Phoenix

You can use global indexes for READ-heavy use cases. Each global index is stored in its own table, and thus is not co-located with the data table.

With global indexes, you can disperse the READ load between the main and secondary index table on different RegionServers serving different sets of access patterns. A Global index is a covered index. It is used for queries only when all columns in that query are included in that index.