Secondary indexes Secondary indexes have been in Cassandra since 0.7 and can be incredibly useful. For example, if you were implementing a user accounts database, you might have the schema CREATE TABLE user_accounts ( username text PRIMARY KEY, email text, password text, last_visited timestamp, country text ); The only key you can lookup on is… Continue reading The sweet spot for Cassandra secondary indexing