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
I have two questions,
1. Does creating secondary index on low cardinality columns like of boolean
type helps in read performance any ways? Because there will be only two
values( true and false ) for that column in index table.
2. Should secondary indexes be created on clustering columns even if th
