Assume this schema CREATE TABLE t( a int, b int, c int, d int, e text, f date, g int, PRIMARY KEY (a,b) )
I we create following mv CREATE MATERIALIZED VIEW t_mv as select a,b,c,d from t where c is not null and d is not null PRIMARY KEY (c,d,a,b); What happens if we run this query UPDATE t SET g=1 WHERE a=10 AND b = 20 As you can see "g" is excluded in "t_mv" , I want to know what cassandra doing internaly? Is there any overhead for t_mv , or cassandra smartly detect there is no changes for t_mv and no-operation for example If we have 10 materialized view like above-mentioned , is Update that excluded in mv impact performance? or the performance in equal to when there is no mv