Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, speed up your database, and improve the performance of your application.

Try CockroachDB serverless (it's free): https://cockroachlabs.cloud/signup

0:00 Introduction
0:05 Example database table
0:15 Sample question
0:21 The problem with a full table scan
0:50 Use EXPLANATION ANALYSIS
1:04 What is an SQL index?
1:17 Create a single-column index
1:37 Create a multi-column index
2:08 Optimizing our SQL query
2:31 Caveats on SQL indexes

Blog: https://www.cockroachlabs.com/blog/sql-performance-best-practices/
Documents: https://www.cockroachlabs.com/docs/stable/performance-best-practices-overview.html
Free course: https://university.cockroachlabs.com/courses/course-v1:crl+getting-started-with-sql-for-app-devs+self-paced/about

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.