Indexing a column

Using cqlsh to create an index on column values.

You can use cqlsh to create an index on column values. In Apache Cassandra™ 2.1 and later, you can index collection columns. Indexing can impact performance greatly. Before creating an index, be aware of when and when not to create an index.

Procedure

  1. Creates an index on the state and birth_year columns in the users table. 
    cqlsh:demodb> CREATE INDEX state_key ON users (state);
cqlsh:demodb> CREATE INDEX birth_year_key ON users (birth_year);
  2. Query the columns that are now indexed. 
    cqlsh:demodb> SELECT * FROM users
                WHERE gender = 'f' AND
                state = 'TX' AND
                birth_year > 1968
                ALLOW FILTERING;