Rebuilding and maintaining secondary indexes (2i)

tables as indexes must be created manually; for example, if the artists column had been indexed by creating a table such as songs_by_artist, your client application would have to populate the table with data from the songs table. nodetool rebuild_index command.