|
|
|
|
|
by djrobstep
2351 days ago
|
|
Materialized views are fundamentally just some syntactical sugar over the results of a query cached in a table. The syntactical sugar does have advantages, but comes at a cost of flexibility - if you need more control over the update process or modification of the data than a full refresh, then you should just use a table (create table whatever as select * from ...). |
|