The CREATE INDEX command is used to create an index in the Cassandra table. In this lesson, I will show you how to create and drop index in Cassandra.
Note: You can't create an index on PRIMARY KEY because the primary key is already an index. Cassandra can't filter a column without indexing.
CREATE INDEX index_identifier ON table_info
CREATE INDEX emploayee_name_index ON employees (name) ;
DROP INDEX index_identifier
DROP INDEX emploayee_name_index;