https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-secondardy-index-selection-type/m-p/138464#M35314 <P>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.</P><P>More info:</P><P>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.</P> Wed, 20 Jul 2016 22:54:47 GMT sunile_manjee 2016-07-20T22:54:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-secondardy-index-selection-type/m-p/138464#M35314 <P>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.</P><P>More info:</P><P>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.</P> Wed, 20 Jul 2016 22:54:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-secondardy-index-selection-type/m-p/138464#M35314 sunile_manjee 2016-07-20T22:54:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-secondardy-index-selection-type/m-p/138465#M35315 <P>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.</P> Thu, 21 Jul 2016 01:15:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-secondardy-index-selection-type/m-p/138465#M35315 speleato 2016-07-21T01:15:58Z