I am trying to decide whether to use secondary indexes or use an inverted index column family for a use case. Is there any suggested ballpark range for low cardinality for which secondary indexes are suitable.
Meaning at what range should  using a secondary index be ruled in or out: cardinality of tens, hundreds, thousands,millions?
I am not looking for any tested numbers a general suggestion/best practice recommendation will suffice.