Support Questions
Find answers, ask questions, and share your expertise

Phoenix secondardy index selection type

Super Guru

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.

1 ACCEPTED SOLUTION

Accepted Solutions

New Contributor

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.

View solution in original post

1 REPLY 1

New Contributor

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.

View solution in original post