> Aaron Morton can confirm but I think one problem could be that to create an > index on a field with small number of possible values is not good. Yes. In cassandra each value in the index becomes a single row in the internal secondary index CF. You will end up with a huge row for all the values with false.
And in general, if you want a queue you should use a queue. Cheers ----------------- Aaron Morton Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 14/07/2013, at 1:51 AM, Shahab Yunus <shahab.yu...@gmail.com> wrote: > Aaron Morton can confirm but I think one problem could be that to create an > index on a field with small number of possible values is not good. > > Regards, > Shahab > > > On Sat, Jul 13, 2013 at 9:14 AM, Tristan Seligmann <mithra...@mithrandi.net> > wrote: > On Fri, Jul 12, 2013 at 10:38 AM, aaron morton <aa...@thelastpickle.com> > wrote: >> CREATE INDEX ON conv_msgdata_by_participant_cql(msgReadFlag); > On general this is a bad idea in Cassandra (also in a relational DB IMHO). > You will get poor performance from it. > > Could you elaborate on why this is a bad idea? > -- > mithrandi, i Ainil en-Balandor, a faer Ambar >