With the help of David’s training about advanced SQL you composed a number of useful queries. You gain valuable insights from the resulting data. However these complex queries take time to run. If only you could make them run faster. I think we have just what you need coming up.
Join us for a free webinar Understanding and Tuning Presto Query Processing with Martin Traverso.
In our new Presto Training Series we give Presto users an opportunity to learn advanced skills from the co-creators of Presto – David Phillips, Martin Traverso and Dain Sundstrom. Beyond the basics, each of the four training sessions covers critical topics for scaling Presto to more users and use cases.
In this training session Martin helps to understand how Presto executes query. That knowledge can help you improve query performance. For instance, the explain plan is a powerful tool, but reading the plans and make sense of them can be overwhelming. We explore how to create an explain plan for you query and how to read it. We look at the work the cost-based optimizer performs and how you can potentially help Presto run your queries even faster. This session covers to following topics:
- Explain the EXPLAIN
- Learn how queries are analyzed and executed
- Understand what the optimizer does, including some of its limitations
- Showcase the cost-based optimizer
Date: Wednesday, 12 August 2020
Time: 10am PDT (San Francisco), 1pm EDT (New York), 6pm BST (London), 5pm UTC
We look forward to many Presto users joining us.