> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-postgresql-tls-support.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:

<CardGroup cols={2}>
  <Card title="Schema Design" icon="pen-ruler" href="/guides/clickhouse/data-modelling/schema-design">
    ClickHouse schema design for optimal performance, considering factors like queries, data updates, latency, and volume.
  </Card>

  <Card title="Sparse primary indexes" icon="key" href="/guides/clickhouse/data-modelling/sparse-primary-indexes">
    A practical introduction to primary indexes in ClickHouse.
  </Card>

  <Card title="Denormalizing Data" icon="table-list" href="/guides/clickhouse/data-modelling/denormalization">
    The denormalization approach, which aims to improve query performance by storing related data in a single table.
  </Card>

  <Card title="Backfilling Data" icon="clock-rotate-left" href="/guides/clickhouse/data-modelling/backfilling">
    Techniques for efficiently backfilling data into ClickHouse tables.
  </Card>

  <Card title="Merge table function" icon="code-merge" href="/guides/clickhouse/data-modelling/merge-table-function">
    Using the `merge` table function to query multiple tables as one.
  </Card>

  <Card title="Stored procedures and prepared statements" icon="database" href="/guides/clickhouse/data-modelling/stored-procedures-and-prepared-statements">
    Stored procedures and query parameters in ClickHouse.
  </Card>

  <Card title="Generating test data" icon="flask" href="/guides/clickhouse/data-modelling/generating-test-data">
    How to generate random test data in ClickHouse.
  </Card>

  <Card title="Data Compression" icon="file-zipper" href="/guides/clickhouse/data-modelling/compression/compression-in-clickhouse">
    Compression in ClickHouse and the available compression modes, and how to choose the right one for your data types and workloads.
  </Card>

  <Card title="Working with arrays" icon="list-ol" href="/guides/clickhouse/working-with-arrays">
    Working with arrays in ClickHouse.
  </Card>

  <Card title="Working with JOINs" icon="link" href="/guides/clickhouse/working-with-joins">
    Working with JOINs in ClickHouse.
  </Card>
</CardGroup>