---
url: 'https://altinity.com/webinarspage/2020-02-26-clickhouse-materialized-views-the-magic-continues'
title: 'Webinar. ClickHouse® Materialized Views. The Magic Continues'
author:
  name: Robert Hodges
  url: 'https://altinity.com/author/robertaltinity/'
date: '2020-02-26T18:52:00-08:00'
modified: '2020-02-26T18:52:00-08:00'
type: post
summary: 'Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Watch this replay to learn how to use materialized views to speed up queries hundreds of times. We''ll cover basic...'
categories:
  - Webinars
tags:
  - ClickHouse
  - Materialized Views
image: 'https://altinity.com/wp-content/uploads/2020/02/WebinarsquarepictureFeb26-2.png'
published: true
---

# Webinar. ClickHouse® Materialized Views. The Magic Continues

*February 26, 2020*  
with Robert Hodges

Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Join this updated webinar to learn how to use materialized views to speed up queries hundreds of times. We’ll cover basic design, last point queries, using TTLs to drop source data, counting unique values, and other useful tricks. Finally, we’ll cover recent improvements that make materialized views more useful than ever. See you there!

Speaker Bio: Robert Hodges is CEO of Altinity, which offers enterprise support for ClickHouse. He has over three decades of experience in data management spanning 20 different DBMS types. ClickHouse is his current favorite. 

**Here are the slides:**

[ClickHouse-Materialized-Views-The-Magic-Continues-1](https://altinity.com/wp-content/uploads/2024/05/ClickHouse-Materialized-Views-The-Magic-Continues-1.pdf)[Download](https://altinity.com/wp-content/uploads/2024/05/ClickHouse-Materialized-Views-The-Magic-Continues-1.pdf)