> > There are 4 secondary indexes for users and 3 for messages. I've seen > something odd here: the index of the CFs is also stored in a column > AND is also indexed. There isn't any query by that secondary index. I > should probably erase the index, shouldn't I?
What is the cardinality like on these indexes? Can you provide the schema creation for these two column families?