DataStax announced the general availability of Storage-Attached Indexing (SAI) for Apache Cassandra available on Astra and DataStax Enterprise (DSE). DataStax has also opened a Cassandra Enhancement Proposal (CEP) with the Apache Cassandra project to share this with the open source community. With Storage-Attached Indexing, developers now have accessibility to familiar indexing and queries – such as WHERE clauses – in Apache Cassandra. Storage-Attached Indexing is an index implementation that enables users to index multiple columns on the same table without scaling issues. The benefits of Storage-Attached Indexing include:

  • Improved stability
  • Significantly reduces disk usage
  • Improved numeric range performance
  • Releases constraints to data modeling and barriers to scale-out
  • Features modern and expected indexing features on Apache Cassandra