Secondary indexing (2i) overview

Secondary indexing (2i) allows you create one or multiple secondary indexes on the same database table, with each 2i based on any column.

there is no need to define an 2i based on a single-column partition key.

What is 2i?

General concepts of secondary indexing (2i).

Create 2i index

Create a secondary index (2i) on a table.

Check 2i index existence

Check if a 2i index exists on a table .

Alter 2i index

Alter a 2i index on a table.

Drop 2i index

Drop a 2i index on a table.

Query 2i index

Run queries using 2i indexes.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000,