Query with SSTable-attached secondary indexes (SASI)

Astra DB and DSE 6.9 do not support SSTable-Attached Secondary Indexing (SASI). SASI is an experimental feature in Apache Cassandra® and Hyper-Converged Database, and a beta feature in DataStax Enterprise 6.8.

DataStax does not recommend using SASI in production. Instead, use Storage Attached Indexes (SAI) for indexing in Cassandra 5.0 or later, DSE 6.8 or later, HCD, and Astra DB.

Storage-attached indexes (SAI) can be used in queries to improve performance. SAIs are not a replacement for primary keys, but can be used to improve performance in some cases.

Prerequisites

Keyspace created
Table created
SAI created

Query using SASI:

  SELECT * FROM cycling.cyclist_base WHERE name LIKE 'A%';

Results

Query with SSTable-attached secondary indexes (SASI)

Prerequisites

Was this helpful?

Give Feedback