Re: Reading data from disk

2023-01-04 Thread Lapo Luchini
Hi, I'm not part of the team, I reply as a fellow user. Columns which are part of the PRIMARY KEY are always indexed and used to optimize the query, but it also depends in how the partition key is defined. Details here in the docs: https://cassandra.apache.org/doc/latest/cassandra/cql/ddl.

Reading data from disk

2023-01-03 Thread Inquistive allen
Hello Team, Here is a simple query. Whenever a select query is being run with cluster columns in where clause, does it happen that the entire partition is being read from disk to memory and then iterated over to fetch the required result set. Or there are indexes in place which help read only spe