Drop a SSTable-attached secondary index (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.

SASI indexes can be dropped (deleted).

Prerequisites

Keyspace created
Table created

To drop a SASI index:

  DROP INDEX IF EXISTS cycling.name_sasi_idx;

Drop a SSTable-attached secondary index (SASI)

Prerequisites

Was this helpful?

Give Feedback