Materialized views explained

Mark Needham

Transform your ClickHouse queries with materialized views! This video breaks down the two types— incremental and refreshable materialized views—and shows how they can dramatically improve your query performance. Learn when to use each type and how they process data differently and see practical examples of both in action.

Perfect for database engineers and developers looking to optimize their ClickHouse implementations.

This guide will help you choose your use case, whether you're handling real-time data processing or scheduled updates.

Recent videos

YouTube Video: GwCRcRa8f3A

Open House

Open House 2026: Day 1 Keynote

The latest ClickHouse announcements, featuring real-world use cases from Shopify, Zoox, Visa, and Cisco.

YouTube Video: ZtvlCz7Ukg4

Open House

Fireside Chat: The state of data and AI with Bret Taylor (Sierra) and Aaron Katz (ClickHouse)

Aaron Katz (CEO, ClickHouse) and Bret Taylor (Co-Founder Sierra, Chairman of the Board, OpenAI) have an open conversation on the state of AI.

YouTube Video: FmS7VopaqNg

Open House, ClickHouse

How to build a great database (Alexey Milovidov)

The principles behind building a great database, and the new frontiers shaping the field.

Follow us

XBlueskySlackGithubTelegramMeetupRSS