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

 cid                                  | age | birthday   | country       | name
--------------------------------------+-----+------------+---------------+--------------
 15a116fc-b833-4da6-ab9a-4a7775752836 |  18 | 1997-08-19 | United States | Adrien COSTA
 e7ae5cf3-d358-4d99-b900-85902fda9bb0 |  22 | 1993-06-18 |   New Zealand |   Alex FRAME

(2 rows)

Warnings :
SASI index was enabled for 'cycling.cyclist_base'. SASI is still in beta, take extra caution when using it in production.

Query with SSTable-attached secondary indexes (SASI)

Prerequisites

Was this helpful?

Give Feedback