Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix secondardy index selection type

Solved Go to solution

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

Re: Phoenix secondardy index selection type

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.

1 REPLY 1

Re: Phoenix secondardy index selection type

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.

Don't have an account?
Coming from Hortonworks? Activate your account here