Phoenix secondardy index selection type

[#1]

I am determine what type of secondary index to use on my phoenix table. By reading the documentation, Global index are used for read heavy use case, and local are used for write heavy use case. I have a balanced read/write use case. Which index should I consider.

More info:

When I perform a select it is against all columns in the table. The where clause is on 1 column. this is the column I want to index. Again read/write balanced used case.

[#2 · Accepted solution]

Assuming the read/write balance is going to continue on the future, and assuming performance on both of those actions is equally important, I would recommend global index.