> ## Documentation Index
> Fetch the complete documentation index at: https://www.propeldata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# What is ClickHouse®?

> Learn why ClickHouse is **so fast** for analytical use cases.

<div />

ClickHouse® is an open-source, high-performance, column-oriented SQL database for analytical workloads.

## Why is ClickHouse so fast?

<CardGroup cols={2}>
  <Card title="Columnar storage" icon="square-1">
    Data is stored in columns rather than rows, allowing for efficient compression and faster analytical queries.
  </Card>

  <Card title="Vectorized query execution" icon="square-2">
    ClickHouse processes data in chunks, utilizing modern CPU architectures more effectively.
  </Card>

  <Card title="Parallel processing" icon="square-3">
    Queries are automatically parallelized across multiple CPU cores and servers.
  </Card>

  <Card title="Data compression" icon="square-4">
    Advanced compression algorithms reduce I/O operations and memory usage.
  </Card>

  <Card title="Optimized data structures" icon="square-5">
    ClickHouse uses specialized data structures tailored for analytical workloads.
  </Card>

  <Card title="Just-in-time compilation" icon="square-6">
    Complex queries are compiled to native machine code for faster execution.
  </Card>
</CardGroup>

How fast? See the [benchmarks](https://benchmark.clickhouse.com).

These features combined allow ClickHouse to process billions of rows and gigabytes of data in seconds, making it ideal for real-time analytics on large datasets.

## Use cases

<CardGroup cols={1}>
  <Card title="Real-time analytics" icon="chart-line" horizontal="true">
    Analyze data as it's generated for instant insights and rapid decision-making.
  </Card>

  <Card title="Customer-facing analytics" icon="chart-user" horizontal="true">
    Provide customers with powerful, interactive data insights directly in your product.
  </Card>

  <Card title="Operational analytics" icon="chart-column" horizontal="true">
    Monitor and optimize business processes in real-time for improved efficiency.
  </Card>

  <Card title="Observability" icon="magnifying-glass" horizontal="true">
    Gain deep visibility into complex systems for proactive issue detection and resolution.
  </Card>

  <Card title="Business intelligence" icon="magnifying-glass-chart" horizontal="true">
    Transform raw data into actionable insights to drive strategic business decisions.
  </Card>

  <Card title="Data warehouse" icon="database" horizontal="true">
    Centralize and store large volumes of data for comprehensive analysis and reporting.
  </Card>
</CardGroup>