http://www.datastax.com/support-forums/topic/performance-of-cassandra-with-multiple-secondary-indexes Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 23:06:23 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/performance-of-cassandra-with-multiple-secondary-indexes#post-6600 Thu, 20 Sep 2012 14:50:01 +0000 xedin 6600@http://www.datastax.com/support-forums/ <p>The only option I see would be to try to build a composite column of those 6 and query it instead of secondary indices, this should be a good start <a href="http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1" rel="nofollow">http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1</a> </p> http://www.datastax.com/support-forums/topic/performance-of-cassandra-with-multiple-secondary-indexes#post-6599 Thu, 20 Sep 2012 14:38:52 +0000 rprvnreddy 6599@http://www.datastax.com/support-forums/ <p>We are asking this for guidance on high performing schema design with secondary indexes for reads. We have 7 columns in a column family. Our queries need to retrieve rows by setting where clause for 6 of the columns. Due to this reason we are adding secondary indexes for these 6 columns. We are noticing that as we increase the "where" clauses in cassandra-cli client the performance degrades. We checked this behavior with "Astyanax" java client.<br /> Can you please suggest how we go about increasing the read performance. </p>