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.
Thanks. -Adi
