Query with secondary indexes (2i)

Secondary indexes (2i) can be used in queries to improve performance. 2i are not a replacement for primary keys, but can be used to improve performance in some cases.

Prerequisites

Keyspace created
Table created
Secondary index created

Query using secondary index:

SELECT * FROM cycling.rank_by_year_and_name
  WHERE race_year = 2014 
  AND race_name  = 'Tour of Japan - Stage 4 - Minami > Shinshu';

Results

 race_year | race_name                                  | rank | cyclist_name
-----------+--------------------------------------------+------+----------------------
      2014 | Tour of Japan - Stage 4 - Minami > Shinshu |    1 |        Daniel MARTIN
      2014 | Tour of Japan - Stage 4 - Minami > Shinshu |    2 | Johan Esteban CHAVES
      2014 | Tour of Japan - Stage 4 - Minami > Shinshu |    3 |      Benjamin PRADES

(3 rows)

Query with secondary indexes (2i)

Prerequisites

Was this helpful?

Give Feedback