Hi Sumit, Every use case is different, that's why we created the Pherf tool[1] so you could try representative data sets over various different variations in schema in a multi threaded environment. Please share what you find with us so the community can build up this knowledge. Thanks, James
[1] https://phoenix.apache.org/pherf.html On Sun, Sep 20, 2015 at 10:09 PM, Sumit Nigam <[email protected]> wrote: > Hi, > > I had some doubt about local vs global indexes in Phoenix. > > In my use case, I have both read and write heavy use cases against the > same tables. So, is it a better idea to use local indexes? > It is also going to help reduce network chatter. > > Plus, my reads may issue queries which fetch non-indexed columns as well. > > Should I keep both global and local indexes on the same secondary index > column? > > Thanks, > Sumit > > >
