Understanding the SQL EXPLAIN command | Starburst Academy
Learn more about how to read and interpret query plans in Starburst Galaxy using SQL: https://academy.starburst.io/explorin....
Starburst Enterprise and Starburst Galaxy are massively parallel processing (MPP), highly performant, federated platforms that allow organizations to query and join data across multiple data sources through a single query. A key component that makes the Starburst query engine highly performant is its cost-based optimizer (CBO).
The CBO chooses an optimal query execution plan based on the cost of each operation required to complete the query. The query plan captures how a query is executed and is an extremely powerful tool to help you understand and improve query performance. Understanding the query plan is a fast track to understanding the Starburst query engine and CBO.
This video walks through using the SQL EXPLAIN command to generate a query plan. It then shows how to read the resulting plan.