From the course: Advanced SQL for Data Scientists
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Optimize a query using an explain plan
From the course: Advanced SQL for Data Scientists
Challenge: Optimize a query using an explain plan
(bright music) - [Instructor] Let's consider a challenge around query performance optimization. So imagine that a colleague has asked you to help them analyze a long-running query that they're working with. Now you take a quick look and you realize, okay, the query has three tables and two left joins. Two of the tables have over 500,000 rows and one table has 200 rows. So given that, how would you proceed to improve the query performance?
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
EXPLAIN and ANALYZE commands7m 41s
-
Generating data with generate_sequence4m 16s
-
Generating time series data6m 35s
-
Analyzing a query with WHERE clauses and indexes2m 46s
-
Analyzing a query with a join5m 57s
-
Challenge: Optimize a query using an explain plan33s
-
Solution: Optimize a query using an explain plan1m 39s
-
-
-
-