Hi All, I have a use-case where in I want to execute query on my cassandra table with different where clauses.
Two approaches know to me is :- Creating secondary index But to my understanding, query on secondary index will be slow. Creating multiple tables with same data but different primary key. This option has many consequences as lot of things needs to be taken care of while writing the data. Please let me know if a better solution is available. I am using 2.1.5 version. Regards, Sam