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 these columns are not frequently used in where clause of a query?
