This article explains when it's OK to use secondary indexes in Cassandra:
http://www.wentnet.com/blog/?p=77
PS: the article is from 2013, so it can be outdated by now.. but at least
it should give you some preliminary background on the topic.
2015-04-29 16:44 GMT-03:00 Robert Coli :
> On Wed, Ap
On Wed, Apr 29, 2015 at 9:01 AM, Donald Smith <
donald.sm...@audiencescience.com> wrote:
> Secondary indicies are inefficient and are deprecated, as far as I know.
>
They are not deprecated, the correct summary is that they should only be
used in very particular circumstances. If you're not sure
Secondary indicies are inefficient and are deprecated, as far as I know.
Unless you store many thousands of emails for a long time (which I recommend
against), just use a single table with the partition key being the userid and
the timestamp being the clustering (column) key, as in your schema.