Toggle Menu

Using Storage-Attached Indexing (SAI) on Astra

DataStax Storage-Attached Indexing (SAI) lets you create one or multiple secondary indexes on the same database table, with each SAI index based on any column. SAI provides more functionality compared to Cassandra secondary indexes, is faster at writes compared to any Cassandra or DSE Search index, and uses significantly less disk space.

CONTRIBUTORS

DataStax Storage-Attached Indexing (SAI) lets you create one or multiple secondary indexes on the same database table, with each SAI index based on any column. SAI provides more functionality compared to Cassandra secondary indexes, is faster at writes compared to any Cassandra or DSE Search index, and uses significantly less disk space.

In this scenario, we'll learn how to:

  • Create an Astra database
  • Install and configure cqlsh
  • Create a table in Astra
  • Create SAI indexes on columns
  • Perform SELECT queries based on indexed columns

Astra is a great Cassandra as a Service offering, making setup easy for us. Let's get started!

Time to Complete

10

Difficulty

Beginner

Share