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
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)