Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

Materialized views

View as MarkdownEdit this pageReport an issueSet up docs MCP
Page Description
Incremental materialized view Allow users to shift the cost of computation from query time to insert time, resulting in faster SELECT queries.
Refreshable materialized view Conceptually similar to incremental materialized views but require the periodic execution of the query over the full dataset - the results of which are stored in a target table for querying.
Cascading materialized views Chain multiple materialized views together to build incremental data transformations.
Navigation