SSTable-Attached Indexing (SASI) Overview

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

What is SASI?

Use SSTable-Attached Indexing (SASI) to create multiple secondary indexes on the same table.

Create SASI index

Create a SASI index on a table.

Check SASI index

Check if a SASI index exists on a table.

Alter SASI index

Alter a SASI index on a table.

Drop SASI index

Drop a SASI index from a table.

SASI queries

Run queries using SASI indexes.

Configure SASI indexes

Configure SASI settings.

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,