> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Data modelling overview

> Overview of Data Modelling

This section is about data modeling in ClickHouse and contains the following topics:

| Page                                                                                                                     | Description                                                                                                                                                                                   |
| ------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Schema Design](/guides/clickhouse/data-modelling/schema-design)                                                         | Discusses ClickHouse schema design for optimal performance, considering factors like queries, data updates, latency, and volume.                                                              |
| [Sparse primary indexes](/guides/clickhouse/data-modelling/sparse-primary-indexes)                                       | A practical introduction to primary indexes in ClickHouse.                                                                                                                                    |
| [Denormalizing Data](/guides/clickhouse/data-modelling/denormalization)                                                  | Discusses the denormalization approach used in ClickHouse which aims to improve query performance by storing related data in a single table.                                                  |
| [Backfilling Data](/guides/clickhouse/data-modelling/backfilling)                                                        | Techniques for efficiently backfilling data into ClickHouse tables.                                                                                                                           |
| [Merge table function](/guides/clickhouse/data-modelling/merge-table-function)                                           | Using the Merge table function to query multiple tables as one.                                                                                                                               |
| [Stored procedures and prepared statements](/guides/clickhouse/data-modelling/stored-procedures-and-prepared-statements) | Stored procedures and query parameters in ClickHouse.                                                                                                                                         |
| [Generating test data](/guides/clickhouse/data-modelling/generating-test-data)                                           | How to generate random test data in ClickHouse.                                                                                                                                               |
| [Data Compression](/guides/clickhouse/data-modelling/compression/compression-in-clickhouse)                              | 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. |
| [Working with arrays](/guides/clickhouse/working-with-arrays)                                                            | Working with arrays in ClickHouse.                                                                                                                                                            |
| [Working with JOINs](/guides/clickhouse/working-with-joins)                                                              | Working with JOINs in ClickHouse.                                                                                                                                                             |