Query with SSTable-attached secondary indexes (SASI)

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