Skip to main content

How to use physical explain plans

In this Cockroach University lesson titled “How to use physical explain plans”, you will learn how a cluster finds information, you’ll see an explain plan diagram, and you’ll get to look at a very complicated explain plan broken down into its parts. In this lesson, you will learn: •00:00 How to use the EXPLAIN ANALYZE statement •0:20 How CockroachDB responds to a query •0:54 How to understand the nodes and indexes involved in a query •1:32 How to interpret the results *This video is an exceprt from our course, "CockroachDB for Python Developers". Learn more about CockroachDB by signing up for free training at Cockroach University: ---------- Reference Links •SQL Performance Best Practices: (CockroachDB Docs) •Indexes: (CockroachDB Docs) ---------- Careers: CockroachCloud: Blog: Docs: Community Slack: Twitter: