It wasn't meant in a snarky way, it was as (too short) explanation. I try to sum it up:
Materialized View: The data that is represented by the view is stored persistently and updated as soon as the underlying base data changes. On RDBMS: Pro: Fast reads, Con: Slow(er) updates On CS: Used to do filtering or sorting of the base table. Much slower write path. "Regular" View: The base data is queried on demand. More or less a rewrite or alias of another query. On RDBMS: Pro: No updates required, Con: Probably slow reads, depending on indexes. On CS: Does not exist. The term "materialized view" has been established by well known RDBMS like oracle and behaves very similar in CS. In most RDBMS a view can have many base tables. In CS an MV can have only one base table and has many more restrictions compared to RDBMS. 2016-12-13 21:06 GMT+01:00 Jonathan Haddad <j...@jonhaddad.com>: > People should be able to ask legit questions here without getting snarky > answers, please don't do that. Not everyone has the same background or > knowledge that you do. > > On Tue, Dec 13, 2016 at 11:49 AM Benjamin Roth <benjamin.r...@jaumo.com> > wrote: > >> The word "materialized" implies that. >> >> 2016-12-13 20:34 GMT+01:00 Carl Yeksigian <c...@yeksigian.com>: >> >> Yes, they are stored on disk like a normal table. >> >> On Tue, Dec 13, 2016 at 2:31 PM, Kant Kodali <k...@peernova.com> wrote: >> >> Are Materialized views persisted on disk? sorry for the naive question. >> >> >> >> >> >> -- >> Benjamin Roth >> Prokurist >> >> Jaumo GmbH · www.jaumo.com >> Wehrstraße 46 · 73035 Göppingen · Germany >> Phone +49 7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 >> <+49%207161%203048801> >> AG Ulm · HRB 731058 · Managing Director: Jens Kammerer >> > -- Benjamin Roth Prokurist Jaumo GmbH · www.jaumo.com Wehrstraße 46 · 73035 Göppingen · Germany Phone +49 7161 304880-6 · Fax +49 7161 304880-1 AG Ulm · HRB 731058 · Managing Director: Jens Kammerer
