I was wondering if there are recommendations around the cardinality of
secondary indexes.

As I understand an index on a column with many distinct values will be
inefficient. Is it because the index would only direct me to the specfic
sstable, but then it sequentially searches for the target records? So a
wide range of the index could lead to a lot of ssltable options to traverse?

Though what's unclear is what the recommended (or benchmarked?) limit, is
it the index must have 100 distinct values, or can it have upto 1000 or
50000 distinct values?



Reply via email to