| Page | Description |
|---|---|
| Schema Design | Discusses ClickHouse schema design for optimal performance, considering factors like queries, data updates, latency, and volume. |
| Dictionary | An explainer on how to define and use dictionaries to improve query performance and enrich data. |
| Materialized Views | Information on Materialized Views and Refreshable Materialized Views in ClickHouse. |
| Projections | Information on Projections in ClickHouse. |
| Data Compression | Discusses various compression modes in ClickHouse and how to optimize data storage and query performance by choosing the right compression method for your specific data types and workloads. |
| Denormalizing Data | Discusses the denormalization approach used in ClickHouse which aims to improve query performance by storing related data in a single table. |
Data modelling overview
Overview of Data Modelling
This section is about data modeling in ClickHouse and contains the following topics:
Last modified on June 19, 2026