Hi, we have a Cassandra table with Partition and Cluster key defined. And Select query is having where clause on Partition Key. But we are seeing performance issue while reading data from table when load increased on the table.
1. I could see that 'Allow Filtering' is enabled. planning to disable that as it doesn't make sense to use when where clause is having filter on partition key. Is it correct thing to do?
2. we are not looking at any data sorting. Is it required to have Cluster key defined on the table? does it create any performance issues with unnecessarily having Cluster key defined?
Please find table schema.
|Column1 Text||Partition Key|
|Column2 Text||Cluster Key|
Select * from Table1 where Column1=' ' ALLOW FILTERING;
I cant provide exact column names due to security reasons, instead renamed Table and Column names.
Hope details will be helpful.
Could you please help in performance improvement options? Thanks in advance.