Cassandra Show all Indices

I am currently working with cassandra indices and its quite difficult to find the best way to find all registered indices. My currently best way is to query the system_schema table, there is no native command or something else to find the indices.

The query to find all index names for your keyspace is:

SELECT index_name FROM system_schema.indexes WHERE keyspace_name = 'mykeyspace'

Have fun!

This article is my 31st oldest. It is 64 words long