Distributed Database Office Hours: How to tune SQL queries

Description

In our weekly Distributed Database Office Hours our gregarious and talented host, Rain Leader, fields questions about how to tune SQL queries. Alistair Parry does a live demonstration of how you can use the DB console to find which queries need to get tuned. But answer a handful of other questions about CockroachDB, MVCC, time travel queries and working within Distributed Systems. 00:00 Introduction to Steven Hand & Alistair Parry 8:00 How to identify bad queries in the DB Console 14:15 When selecting by the primary key 16:20 Finding a query that needs to get tuned 17:20 How the speed of light impacts query speed 47:20 What is a Time Travel query? 52:10 Does CockroachDB maintain multiple versions of data? 52:20 What is MVCC? Cockroach University: https://www.cockroachlabs.com/cockroach-university/ CockroachDB Slack: go.crdb.dev/p/slack CockroachDB Forum: https://forum.cockroachlabs.com/