Storage Attached Indexes provide new secondary index implementation

Cassandra 5.0 introduces Storage Attached Indexes (SAI, CEP-7), a new secondary index implementation that stores index data alongside table data. This provides better performance for secondary index queries compared to legacy secondary indexes.

Evaluate SAI for existing secondary indexes. Monitor cassandra_client_request_read_time_50p for query performance when using SAI. Track cassandra_sstable_live_disk_space_used to measure index storage overhead. Review index-related configuration parameters in CEP-7 documentation.