CrateDB Workshop Module 5: Query Planning and Optimizations

CrateDB Workshop is a hands-on learning experience for novel and experienced users. The workshop introduces the fundamental concepts of CrateDB, a distributed SQL database, and how it can be used to efficiently store, query, and analyze large amounts of data. In this last module, Marios Trivyzas, Senior Software Engineer at CrateDB​, will show you how to further optimize your queries.

00:00 - Introduction
01:38 - Understanding Query Plans
18:31 - Most Common Performances Issues
24:48 - Query Optimizations and Examples
44:20 - Q&A
53:22 - Closing remarks

• Here’s the link to the Distributed Join Algorithms tutorial
• Here’s the link to the Optimize Table documentation:
• Here’s the link to the Analyze Command documentation:
• Here’s the link to the System information
• Here’s the link to Very Slow Query Performance article
• Here’s the link to Implement DPhyp algorithm for join ordering
• Start your CrateDB Cloud Free Tier
• Schedule a meeting with our CrateDB Engineers:
• Join the Open-source CrateDB Community