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.
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.