On Tue, Aug 7, 2012 at 2:32 AM, Baskar Sikkayan <baskar.sks@gmail.com> wrote:

If i create one more column family based on my query instead of going with secondary index,
Will it affect the write performance?

It won't affect writes much more than the built-in secondary indexes would, and you'll get better read performance.
 
Since i need to duplicate the data in the second column family as well while writing data, Will it hit write performance?

Same answer.

--
Tyler Hobbs
DataStax