Secondary indexes (2i) overview

Secondary indexes (2i) allow you create one or multiple secondary indexes on the same database table, with each 2i based on any column. Exception: there is no need to define an 2i based on a single-column partition key.

What is 2i?

Use secondary indexing (2i) to create multiple secondary indexes on the same table.

Create a 2i

Create a secondary index (2i).

Check 2i existence

Check if a 2i exists.

Query 2i

Understand the columns on which you can define SAI indexes and run queries.

Drop 2i

Drop a 2i

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,