On Thu, Oct 8, 2015 at 2:37 AM, anuja jain wrote:
> 1. Does creating secondary index on low cardinality columns like of
> boolean type helps in read performance any ways?
>
No.
> 2. Should secondary indexes be created on clustering columns even if these
> columns are not frequently used in wher
Secondary indexes are not a recommended best practice. Better choices:
1. The new 3.0 materialized views.
2. Manual query tables
3. DSE Search/Solr
4a. Stratio Lucene indexing
4b. TupleJump Stargate Lucene indexing
In any case, low cardinality is not recommended for indexes. The goal is
that a qu
