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

# ClickHouse Concepts

> Explore ClickHouse concepts including materialized views, dictionaries, performance tuning, operations, configuration, security, and more.

<CardGroup cols={2}>
  <Card title="Materialized Views" icon="layer-group" href="/concepts/features/materialized-views">
    Learn about incremental, refreshable, and cascading materialized views.
  </Card>

  <Card title="Dictionaries" icon="book" href="/concepts/features/dictionaries">
    External and internal dictionaries for fast key-value lookups.
  </Card>

  <Card title="Projections" icon="diagram-project" href="/concepts/features/projections/projections">
    Pre-sorted data representations for faster queries.
  </Card>

  <Card title="Performance" icon="gauge-high" href="/concepts/features/performance">
    Prewhere, caches, skipping indexes, lazy materialization, and troubleshooting.
  </Card>

  <Card title="Operations" icon="gears" href="/concepts/features/operations/update">
    Insert, select, update, and delete operations.
  </Card>

  <Card title="Configuration" icon="sliders" href="/concepts/features/configuration/settings/overview">
    Settings, server configuration, and workload scheduling.
  </Card>

  <Card title="Security and Authentication" icon="shield-halved" href="/concepts/features/security">
    Access control, TLS, external authenticators, and network security.
  </Card>

  <Card title="Backup and Restore" icon="box-archive" href="/concepts/features/backup-restore/overview">
    Backup to local disk, S3, Azure Blob Storage, and alternative methods.
  </Card>

  <Card title="Tools and Utilities" icon="wrench" href="/concepts/features/tools-and-utilities">
    clickhouse-local, clickhouse-benchmark, clickhouse-keeper, and more.
  </Card>
</CardGroup>