Developing with CockroachDB: SQL Query Optimizations for Speed & Efficiency

Published: 01 January 1970
on channel: CockroachDB

625

This is a hands-on-keyboard live lab session in which Steven Hand & Rain Leander are going to demonstrate various ways to optimize your SQL queries for speed in some cases and cost/efficiency in other cases. They'll show you how to monitor query performance, what to look for (and where to look) and then they'll give you some different best practices for fixing queries that are behaving poorly.

00:00 Introduction to Developing with CockroachDB
18:00 The Live Demo Begins
18:01 Link to the live lab: https://github.com/cockroachlabs/deve...
19:20 How to use Primary Keys with CockroachDB
21:00 Insert multiple rows with one SQL Statement
21:30 Giving data to CockroachDB
26:45 When is an index in CockroachDB used or not used?
29:30 Demo of fixing a bad query in which an index is used
30:35 Why you see a join when only one table is present in CockroachDB
31:30 Looking at the indexes in a table in CockroachDB (indexes are defined on multiple columns)
32:30 Pulling up a table definition in CockroachDB
35:00 How to do EXPLAIN ANALYZE in CockroachDB
38:00 EXPLAIN a query that does not have an index
39:50 EXPLAIN ANALYZE with a SELECT plan
41:10 How to add a covering index
42:40 how to remove an index scan
43:45 How to performance testing with CockroachDB
44:30 What is cardinality?
45:50 Code audit best practices
48:50 What are Join Methods in relational databases?

There will be an Office Hours session to accompany this stream where Rain & Co. answer any questions about CockroachDB and Query Optimization: • Distributed Database Office Hours: How to ...

On this page of the site you can watch the video online Developing with CockroachDB: SQL Query Optimizations for Speed & Efficiency with a duration of hours minute second in good quality, which was uploaded by the user CockroachDB 01 January 1970, share the link with friends and acquaintances, this video has already been watched 625 times on youtube and it was liked by 18 viewers. Enjoy your viewing!

1,019,015

21K