DataStax News: Astra Streaming now GA with new built-in support for Kafka and RabbitMQ. Read the press release.

Cassandra Total Cost of Ownership Study

Analyst firm, GigaOm, has conducted a comprehensive new study comparing serverless Cassandra with self-managed Cassandra.

Get The Report

Learn Without Fear

We’re excited to share a new learning experience for both new and experienced Cassandra users now at datastax.com/dev.

Try For Free Schedule Demo

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

Difficulty

Beginner