Learning Apache Cassandra - Second Edition

Secondary indexes can only have one column

One major limitation of secondary indexes is that they can only target one column. It would not be legal, for instance, to specify a secondary index such as follows:

CREATE INDEX ON "users" ("email", "encrypted_password");

We'll explore one workaround to this limitation in the Working with tuples section of Chapter 8, Collections, Tuples, and User-Defined Types.