Materialized Views In Depth

6 min to complete

A view is another table, which will take space, and that depending on your partition key can be on different nodes than the base table.
The session goes over what happens behind the scenes when MV are used.
In the write path whenever you write a new record to the base table, ScyllaDB will automatically create a record in the corresponding view.
On the read path, you should query your view directly and reads on the base table will not touch the views. So there is no implicit joining.
It also explains read before write and concurrent updates.