Query optimization with ClickHouse workshop

Date: Wed, Sep 25
Time: 9 a.m. ET / 2 p.m. BST / 3 p.m. CEST
Duration: 2 hours
Cost: FREE

This workshop is recommended for experienced ClickHouse users.

In this 2-hour, instructor-led workshop, you will learn how to optimize queries in ClickHouse. We will dive deep into techniques to improve query performance, such as effective use of primary keys, skipping indexes, materialized views, and projections. We'll also explore strategies to avoid common pitfalls, like inefficient joins and improper data types, while utilizing ClickHouse’s query logs and CPU/memory profiling to identify bottlenecks. By the end of the session, you’ll be equipped with the tools and knowledge to measure and optimize your queries.

There will be both instructor-led training and hands-on labs.