Indexing Tables

Tables can be indexed with these indexing tools:

Storage-attached indexes (SAI)

Storage-attached indexes are attached to SSTables in Cassandra and located on the cluster that a SSTable is located.

SSTable-attached indexes (SASI)

SSTable-attached indexes are generated with SSTables in Cassandra and located on the node that a SSTable is located.

Secondary indexes (2i)

Secondary indexes (2i) are indexes that are written on each node in a Cassandra cluster and must be read from the node.

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,