Well I went with the definition from wikipedia and that definition rules out #1 so it is #2 and it is just one matching row in my case.
On Sat, Oct 15, 2016 at 2:40 AM, DuyHai Doan <doanduy...@gmail.com> wrote: > Define precisely what you mean by "high cardinality columns". Do you mean: > > 1) a single indexed value is present in a lot of rows > 2) a single indexed value has only a few (if not just one) matching row > > > On Sat, Oct 15, 2016 at 8:37 AM, Kant Kodali <k...@peernova.com> wrote: > >> I understand Secondary Indexes in general are inefficient on high >> cardinality columns but since SASI is built from scratch I wonder if the >> same argument applies there? If not, Why? Because I believe primary keys in >> Cassandra are indeed indexed and since Primary key is supposed to be the >> column with highest cardinality why not do the same for secondary indexes? >> > >
